PREVIEW / stock_30min / 2010-12-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-03.parquet
  size:    1.4 MB
  rows:    76,266
  symbols: 3,514

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-12-03 07:00:00	AAPL	Stock	11.3714	11.3839	11.3711	11.3821	267400.0
2010-12-03 07:30:00	AAPL	Stock	11.3886	11.3929	11.38	11.3929	81900.0
2010-12-03 08:00:00	AAPL	Stock	11.3929	11.4018	11.3786	11.3979	1705676.0
2010-12-03 08:30:00	AAPL	Stock	11.3939	11.3993	11.2571	11.2686	9419788.0
2010-12-03 09:00:00	AAPL	Stock	11.2718	11.3214	11.2661	11.3211	4395020.0
2010-12-03 09:30:00	AAPL	Stock	11.3211	11.3564	11.2989	11.3461	66790640.0
2010-12-03 10:00:00	AAPL	Stock	11.3446	11.3804	11.3436	11.3593	45051804.0
2010-12-03 10:30:00	AAPL	Stock	11.3607	11.3657	11.3264	11.3502	24917732.0
2010-12-03 11:00:00	AAPL	Stock	11.3504	11.3536	11.3279	11.3307	16422616.0
2010-12-03 11:30:00	AAPL	Stock	11.3307	11.3321	11.3018	11.3096	21497196.0
2010-12-03 12:00:00	AAPL	Stock	11.3093	11.3236	11.3018	11.3113	12971028.0
2010-12-03 12:30:00	AAPL	Stock	11.3109	11.3211	11.3066	11.3111	10000368.0
2010-12-03 13:00:00	AAPL	Stock	11.3121	11.3168	11.2979	11.305	12204528.0
2010-12-03 13:30:00	AAPL	Stock	11.3043	11.3286	11.3043	11.325	13067320.0
2010-12-03 14:00:00	AAPL	Stock	11.325	11.33	11.3036	11.3093	13815592.0
2010-12-03 14:30:00	AAPL	Stock	11.3104	11.3304	11.3064	11.3271	15362340.0
2010-12-03 15:00:00	AAPL	Stock	11.3275	11.3418	11.3079	11.3393	17229240.0
2010-12-03 15:30:00	AAPL	Stock	11.3389	11.3429	11.3179	11.3382	40458740.0
2010-12-03 16:00:00	AAPL	Stock	11.3357	11.3457	11.3257	11.3307	6785604.0
2010-12-03 16:30:00	AAPL	Stock	11.3314	11.3329	11.3268	11.3307	691264.0
2010-12-03 17:00:00	AAPL	Stock	11.3311	11.3339	11.3307	11.3339	198996.0
2010-12-03 17:30:00	AAPL	Stock	11.3357	11.3357	11.3321	11.3354	53928.0
2010-12-03 18:00:00	AAPL	Stock	11.3325	11.3371	11.3325	11.3332	105588.0
2010-12-03 18:30:00	AAPL	Stock	11.3346	11.3346	11.3321	11.3325	54768.0
2010-12-03 19:00:00	AAPL	Stock	11.3339	11.3357	11.3339	11.3357	101108.0
2010-12-03 19:30:00	AAPL	Stock	11.3357	11.3364	11.3321	11.3343	38108.0
2010-12-03 06:30:00	MSFT	Stock	26.83	26.83	26.8	26.8	500.0
2010-12-03 07:00:00	MSFT	Stock	26.85	26.85	26.85	26.85	700.0
2010-12-03 07:30:00	MSFT	Stock	26.83	26.89	26.83	26.89	600.0
2010-12-03 08:00:00	MSFT	Stock	26.85	26.95	26.83	26.85	16579.0
2010-12-03 08:30:00	MSFT	Stock	26.85	26.85	26.57	26.6	85484.0
2010-12-03 09:00:00	MSFT	Stock	26.6	26.9	26.59	26.82	483996.0
2010-12-03 09:30:00	MSFT	Stock	26.81	26.95	26.78	26.94	6307271.0
2010-12-03 10:00:00	MSFT	Stock	26.94	27.0	26.915	26.979	5458057.0
2010-12-03 10:30:00	MSFT	Stock	26.98	26.99	26.88	26.94	4135366.0
2010-12-03 11:00:00	MSFT	Stock	26.945	26.97	26.87	26.899	3528703.0
2010-12-03 11:30:00	MSFT	Stock	26.9	26.93	26.88	26.92	2663799.0
2010-12-03 12:00:00	MSFT	Stock	26.93	26.97	26.9	26.918	2695539.0
2010-12-03 12:30:00	MSFT	Stock	26.915	26.98	26.9	26.96	2268430.0
2010-12-03 13:00:00	MSFT	Stock	26.96	27.0	26.96	26.97	2808765.0
2010-12-03 13:30:00	MSFT	Stock	26.97	27.0	26.97	26.99	2414479.0
2010-12-03 14:00:00	MSFT	Stock	27.0	27.0	26.98	26.98	1870747.0
2010-12-03 14:30:00	MSFT	Stock	26.99	27.02	26.98	27.01	3338228.0
2010-12-03 15:00:00	MSFT	Stock	27.01	27.03	26.95	27.03	3974460.0
2010-12-03 15:30:00	MSFT	Stock	27.025	27.06	26.99	27.02	6697481.0
2010-12-03 16:00:00	MSFT	Stock	27.02	27.07	26.9	27.04	1772064.0
2010-12-03 16:30:00	MSFT	Stock	27.05	27.05	26.958	27.04	226900.0
2010-12-03 17:00:00	MSFT	Stock	26.9	27.05	26.9	27.02	25269.0
2010-12-03 17:30:00	MSFT	Stock	27.04	27.04	27.04	27.04	600.0
2010-12-03 18:00:00	MSFT	Stock	27.02	27.02	27.02	27.02	22087.0

> showing 50 of 76,266 rows — these rows as CSV

> unlock the full archive -- $79 one-time