PREVIEW / stock_30min / 2009-05-13

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-13.parquet
  size:    1.3 MB
  rows:    73,328
  symbols: 3,320

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
2009-05-13 04:30:00	AAPL	Stock	4.4639	4.4639	4.4639	4.4639	2800.0
2009-05-13 07:00:00	AAPL	Stock	4.4432	4.4432	4.4107	4.425	21000.0
2009-05-13 07:30:00	AAPL	Stock	4.4286	4.4286	4.4143	4.4143	72772.0
2009-05-13 08:00:00	AAPL	Stock	4.4143	4.4214	4.4111	4.4154	434336.0
2009-05-13 08:30:00	AAPL	Stock	4.4154	4.4179	4.4	4.4075	1394988.0
2009-05-13 09:00:00	AAPL	Stock	4.4086	4.4129	4.3975	4.4004	1401596.0
2009-05-13 09:30:00	AAPL	Stock	4.4004	4.4293	4.3814	4.3879	80896844.0
2009-05-13 10:00:00	AAPL	Stock	4.3867	4.3879	4.3389	4.3518	60894736.0
2009-05-13 10:30:00	AAPL	Stock	4.3518	4.3529	4.2986	4.3054	68172384.0
2009-05-13 11:00:00	AAPL	Stock	4.3054	4.3318	4.2929	4.3168	52760680.0
2009-05-13 11:30:00	AAPL	Stock	4.3164	4.3193	4.2989	4.3093	27719244.0
2009-05-13 12:00:00	AAPL	Stock	4.3093	4.3261	4.3082	4.3229	27539400.0
2009-05-13 12:30:00	AAPL	Stock	4.3225	4.3229	4.2886	4.2887	22730316.0
2009-05-13 13:00:00	AAPL	Stock	4.2889	4.3104	4.2886	4.2968	21787192.0
2009-05-13 13:30:00	AAPL	Stock	4.2975	4.3264	4.2914	4.3254	27054524.0
2009-05-13 14:00:00	AAPL	Stock	4.3261	4.3286	4.2925	4.3043	27054944.0
2009-05-13 14:30:00	AAPL	Stock	4.3039	4.3221	4.2925	4.3204	23661764.0
2009-05-13 15:00:00	AAPL	Stock	4.3204	4.3239	4.2893	4.2911	39022480.0
2009-05-13 15:30:00	AAPL	Stock	4.2923	4.2989	4.2643	4.2646	92618176.0
2009-05-13 16:00:00	AAPL	Stock	4.2646	4.3248	4.2636	4.2675	13461952.0
2009-05-13 16:30:00	AAPL	Stock	4.2675	4.4379	4.2643	4.2643	1919484.0
2009-05-13 17:00:00	AAPL	Stock	4.2679	4.2679	4.2543	4.2596	99092.0
2009-05-13 17:30:00	AAPL	Stock	4.2596	4.2679	4.2596	4.2625	138936.0
2009-05-13 18:00:00	AAPL	Stock	4.2604	4.2675	4.2493	4.25	2212868.0
2009-05-13 18:30:00	AAPL	Stock	4.2482	4.2568	4.2475	4.2493	123368.0
2009-05-13 19:00:00	AAPL	Stock	4.25	4.2504	4.2482	4.25	42000.0
2009-05-13 19:30:00	AAPL	Stock	4.25	4.2596	4.2457	4.2539	266252.0
2009-05-13 20:00:00	AAPL	Stock	4.35	4.35	4.35	4.35	39200.0
2009-05-13 04:30:00	MSFT	Stock	20.14	20.14	20.14	20.14	100.0
2009-05-13 06:00:00	MSFT	Stock	20.2	20.2	20.2	20.2	100.0
2009-05-13 07:00:00	MSFT	Stock	19.95	19.95	19.9	19.9	2000.0
2009-05-13 07:30:00	MSFT	Stock	19.9	19.9	19.8	19.8	5900.0
2009-05-13 08:00:00	MSFT	Stock	19.89	19.89	19.81	19.85	6143.0
2009-05-13 08:30:00	MSFT	Stock	19.83	19.89	19.7	19.83	15207.0
2009-05-13 09:00:00	MSFT	Stock	19.83	19.95	19.76	19.92	79564.0
2009-05-13 09:30:00	MSFT	Stock	19.92	20.0	19.8	19.92	6512256.0
2009-05-13 10:00:00	MSFT	Stock	19.94	19.94	19.76	19.88	4679762.0
2009-05-13 10:30:00	MSFT	Stock	19.88	19.89	19.7	19.74	3509193.0
2009-05-13 11:00:00	MSFT	Stock	19.74	19.95	19.73	19.81	3018892.0
2009-05-13 11:30:00	MSFT	Stock	19.81	19.82	19.67	19.72	2311174.0
2009-05-13 12:00:00	MSFT	Stock	19.72	19.88	19.7	19.87	1976220.0
2009-05-13 12:30:00	MSFT	Stock	19.86	19.87	19.72	19.73	1359818.0
2009-05-13 13:00:00	MSFT	Stock	19.73	19.74	19.68	19.71	1665258.0
2009-05-13 13:30:00	MSFT	Stock	19.7	19.81	19.69	19.8	2139848.0
2009-05-13 14:00:00	MSFT	Stock	19.81	19.81	19.685	19.72	1893325.0
2009-05-13 14:30:00	MSFT	Stock	19.72	19.85	19.69	19.83	2914745.0
2009-05-13 15:00:00	MSFT	Stock	19.82	19.83	19.72	19.747	3221794.0
2009-05-13 15:30:00	MSFT	Stock	19.745	19.83	19.7	19.7	9197314.0
2009-05-13 16:00:00	MSFT	Stock	19.7	19.96	19.684	19.691	2700573.0
2009-05-13 16:30:00	MSFT	Stock	19.69	20.05	19.69	19.75	1455231.0

> showing 50 of 73,328 rows — these rows as CSV

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