PREVIEW / stock_30min / 2010-11-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-05.parquet
  size:    1.4 MB
  rows:    78,354
  symbols: 3,511

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-11-05 04:00:00	AAPL	Stock	11.3393	11.3393	11.3393	11.3393	11200.0
2010-11-05 05:30:00	AAPL	Stock	11.3136	11.3136	11.3136	11.3136	2800.0
2010-11-05 06:00:00	AAPL	Stock	11.2932	11.3043	11.2932	11.3043	5600.0
2010-11-05 06:30:00	AAPL	Stock	11.2946	11.2946	11.29	11.29	30520.0
2010-11-05 07:00:00	AAPL	Stock	11.29	11.3168	11.29	11.3168	91840.0
2010-11-05 07:30:00	AAPL	Stock	11.3168	11.3314	11.3168	11.3275	79520.0
2010-11-05 08:00:00	AAPL	Stock	11.3221	11.3371	11.3214	11.325	1146404.0
2010-11-05 08:30:00	AAPL	Stock	11.3321	11.3925	11.3225	11.3489	6911520.0
2010-11-05 09:00:00	AAPL	Stock	11.3489	11.3632	11.3429	11.3582	767704.0
2010-11-05 09:30:00	AAPL	Stock	11.3532	11.4132	11.3321	11.3639	79061388.0
2010-11-05 10:00:00	AAPL	Stock	11.3639	11.3814	11.3511	11.36	29221696.0
2010-11-05 10:30:00	AAPL	Stock	11.3593	11.3959	11.3557	11.365	28822416.0
2010-11-05 11:00:00	AAPL	Stock	11.3646	11.3696	11.3475	11.3566	18824764.0
2010-11-05 11:30:00	AAPL	Stock	11.3568	11.3704	11.3393	11.3396	19454792.0
2010-11-05 12:00:00	AAPL	Stock	11.3393	11.36	11.3357	11.3439	14029792.0
2010-11-05 12:30:00	AAPL	Stock	11.345	11.365	11.3429	11.3614	10532844.0
2010-11-05 13:00:00	AAPL	Stock	11.3611	11.3786	11.3604	11.3716	12783568.0
2010-11-05 13:30:00	AAPL	Stock	11.3714	11.375	11.3607	11.3656	9869356.0
2010-11-05 14:00:00	AAPL	Stock	11.3671	11.3689	11.3254	11.3357	19485032.0
2010-11-05 14:30:00	AAPL	Stock	11.3357	11.3632	11.3357	11.3529	13740216.0
2010-11-05 15:00:00	AAPL	Stock	11.3532	11.3593	11.3393	11.3479	17814692.0
2010-11-05 15:30:00	AAPL	Stock	11.3479	11.3529	11.3125	11.3261	60319980.0
2010-11-05 16:00:00	AAPL	Stock	11.3236	11.3566	11.3061	11.3304	12374236.0
2010-11-05 16:30:00	AAPL	Stock	11.3477	11.3499	11.3264	11.335	306040.0
2010-11-05 17:00:00	AAPL	Stock	11.3311	11.3311	11.3254	11.33	81788.0
2010-11-05 17:30:00	AAPL	Stock	11.3296	11.3336	11.3271	11.3286	28028.0
2010-11-05 18:00:00	AAPL	Stock	11.3318	11.3339	11.3307	11.3339	130816.0
2010-11-05 18:30:00	AAPL	Stock	11.3307	11.3393	11.3261	11.3375	278656.0
2010-11-05 19:00:00	AAPL	Stock	11.3393	11.3489	11.3382	11.3446	153580.0
2010-11-05 19:30:00	AAPL	Stock	11.3429	11.355	11.3393	11.3546	206752.0
2010-11-05 07:00:00	MSFT	Stock	27.13	27.13	27.05	27.05	1200.0
2010-11-05 07:30:00	MSFT	Stock	27.13	27.13	27.05	27.05	900.0
2010-11-05 08:00:00	MSFT	Stock	27.09	27.1	27.04	27.05	11485.0
2010-11-05 08:30:00	MSFT	Stock	27.07	27.25	27.05	27.17	133407.0
2010-11-05 09:00:00	MSFT	Stock	27.17	27.21	27.17	27.17	29987.0
2010-11-05 09:30:00	MSFT	Stock	27.17	27.19	26.86	26.88	10345111.0
2010-11-05 10:00:00	MSFT	Stock	26.88	26.9	26.63	26.693	15589384.0
2010-11-05 10:30:00	MSFT	Stock	26.7	26.75	26.65	26.66	7911626.0
2010-11-05 11:00:00	MSFT	Stock	26.665	26.705	26.53	26.66	10898255.0
2010-11-05 11:30:00	MSFT	Stock	26.668	26.73	26.62	26.63	5120141.0
2010-11-05 12:00:00	MSFT	Stock	26.64	26.73	26.62	26.7	3798047.0
2010-11-05 12:30:00	MSFT	Stock	26.7	26.86	26.675	26.84	3793822.0
2010-11-05 13:00:00	MSFT	Stock	26.839	26.91	26.82	26.86	3095840.0
2010-11-05 13:30:00	MSFT	Stock	26.86	26.89	26.81	26.81	1117361.0
2010-11-05 14:00:00	MSFT	Stock	26.818	26.86	26.67	26.67	4331910.0
2010-11-05 14:30:00	MSFT	Stock	26.67	26.71	26.65	26.665	3585120.0
2010-11-05 15:00:00	MSFT	Stock	26.67	26.72	26.65	26.713	4590085.0
2010-11-05 15:30:00	MSFT	Stock	26.71	26.85	26.65	26.84	12078023.0
2010-11-05 16:00:00	MSFT	Stock	26.84	26.855	26.73	26.81	3049642.0
2010-11-05 16:30:00	MSFT	Stock	26.81	26.83	26.68	26.8	66760.0

> showing 50 of 78,354 rows — these rows as CSV

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