PREVIEW / stock_30min / 2019-06-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-20.parquet
  size:    1.7 MB
  rows:    86,469
  symbols: 2,605

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
2019-06-20 04:00:00	AAPL	Stock	50.0	50.1	50.0	50.075	8760.0
2019-06-20 04:30:00	AAPL	Stock	50.09	50.1375	50.075	50.075	11228.0
2019-06-20 05:00:00	AAPL	Stock	50.1	50.15	50.1	50.125	7500.0
2019-06-20 05:30:00	AAPL	Stock	50.1725	50.2075	49.97	49.97	36336.0
2019-06-20 06:00:00	AAPL	Stock	50.1	50.1	49.9925	50.0	11016.0
2019-06-20 06:30:00	AAPL	Stock	50.0025	50.1125	50.0	50.0875	32436.0
2019-06-20 07:00:00	AAPL	Stock	50.0625	50.1375	50.0	50.1	110804.0
2019-06-20 07:30:00	AAPL	Stock	50.0875	50.125	50.0575	50.105	101376.0
2019-06-20 08:00:00	AAPL	Stock	50.1225	50.2275	50.0	50.205	231184.0
2019-06-20 08:30:00	AAPL	Stock	50.205	50.2475	50.1375	50.1375	169288.0
2019-06-20 09:00:00	AAPL	Stock	50.1675	50.21	50.0	50.04	272936.0
2019-06-20 09:30:00	AAPL	Stock	50.0925	50.1525	49.77	49.9225	12290904.0
2019-06-20 10:00:00	AAPL	Stock	49.9275	49.995	49.6388	49.6838	6860060.0
2019-06-20 10:30:00	AAPL	Stock	49.6875	49.79	49.605	49.7125	5243792.0
2019-06-20 11:00:00	AAPL	Stock	49.7175	49.855	49.65	49.6975	3845696.0
2019-06-20 11:30:00	AAPL	Stock	49.6975	49.825	49.6612	49.785	3144080.0
2019-06-20 12:00:00	AAPL	Stock	49.7875	49.805	49.5075	49.705	4494624.0
2019-06-20 12:30:00	AAPL	Stock	49.7062	49.795	49.6525	49.7675	2773140.0
2019-06-20 13:00:00	AAPL	Stock	49.77	49.8675	49.745	49.8475	2550400.0
2019-06-20 13:30:00	AAPL	Stock	49.8475	49.8812	49.745	49.79	1855272.0
2019-06-20 14:00:00	AAPL	Stock	49.7825	49.8872	49.755	49.835	2593036.0
2019-06-20 14:30:00	AAPL	Stock	49.8368	49.8725	49.7992	49.8625	2199484.0
2019-06-20 15:00:00	AAPL	Stock	49.8625	49.895	49.745	49.8825	3253564.0
2019-06-20 15:30:00	AAPL	Stock	49.88	49.9975	49.8425	49.8448	9398516.0
2019-06-20 16:00:00	AAPL	Stock	49.865	49.915	49.8425	49.85	9077992.0
2019-06-20 16:30:00	AAPL	Stock	49.8425	49.8725	49.8325	49.8375	40280.0
2019-06-20 17:00:00	AAPL	Stock	49.8325	49.835	49.7575	49.7575	39016.0
2019-06-20 17:30:00	AAPL	Stock	49.755	49.7875	49.755	49.7625	12492.0
2019-06-20 18:00:00	AAPL	Stock	49.775	49.7875	49.7225	49.7625	10880.0
2019-06-20 18:30:00	AAPL	Stock	49.7875	49.8	49.745	49.745	19364.0
2019-06-20 19:00:00	AAPL	Stock	49.7225	49.7625	49.7225	49.7625	3712.0
2019-06-20 19:30:00	AAPL	Stock	49.775	49.825	49.775	49.8225	11288.0
2019-06-20 04:00:00	MSFT	Stock	136.83	137.1	136.83	137.1	1755.0
2019-06-20 04:30:00	MSFT	Stock	137.24	137.46	137.24	137.46	300.0
2019-06-20 05:00:00	MSFT	Stock	137.32	137.46	137.29	137.46	4141.0
2019-06-20 05:30:00	MSFT	Stock	137.46	137.6	137.46	137.5	2279.0
2019-06-20 06:00:00	MSFT	Stock	137.51	137.75	137.38	137.61	5400.0
2019-06-20 07:00:00	MSFT	Stock	137.44	137.63	137.43	137.5	9331.0
2019-06-20 07:30:00	MSFT	Stock	137.56	137.68	137.5	137.5	19554.0
2019-06-20 08:00:00	MSFT	Stock	137.59	137.95	137.42	137.65	30718.0
2019-06-20 08:30:00	MSFT	Stock	137.8	138.1	137.6	137.69	36702.0
2019-06-20 09:00:00	MSFT	Stock	137.65	137.9	137.32	137.64	64515.0
2019-06-20 09:30:00	MSFT	Stock	137.45	137.66	137.01	137.24	3322565.0
2019-06-20 10:00:00	MSFT	Stock	137.25	137.4	136.62	136.65	1718329.0
2019-06-20 10:30:00	MSFT	Stock	136.66	136.86	136.28	136.355	1730986.0
2019-06-20 11:00:00	MSFT	Stock	136.36	136.87	136.33	136.618	1220963.0
2019-06-20 11:30:00	MSFT	Stock	136.62	136.88	136.49	136.69	1032587.0
2019-06-20 12:00:00	MSFT	Stock	136.69	136.73	135.72	136.15	1626871.0
2019-06-20 12:30:00	MSFT	Stock	136.13	136.345	135.85	136.005	1087689.0
2019-06-20 13:00:00	MSFT	Stock	136.01	136.3	135.79	136.275	823041.0

> showing 50 of 86,469 rows — these rows as CSV

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