PREVIEW / etf_30min / 2020-01-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-10.parquet
  size:    538 KB
  rows:    18,803

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
2020-01-10 04:00:00	SPY	ETF	327.22	327.3	327.15	327.3	3117.0
2020-01-10 04:30:00	SPY	ETF	327.33	327.41	327.32	327.4	2609.0
2020-01-10 05:00:00	SPY	ETF	327.43	327.5	327.41	327.41	1250.0
2020-01-10 05:30:00	SPY	ETF	327.49	327.5	327.42	327.42	2670.0
2020-01-10 06:00:00	SPY	ETF	327.41	327.73	327.41	327.7	15430.0
2020-01-10 06:30:00	SPY	ETF	327.68	327.74	327.55	327.58	13711.0
2020-01-10 07:00:00	SPY	ETF	327.58	327.58	327.42	327.45	64441.0
2020-01-10 07:30:00	SPY	ETF	327.43	327.51	327.36	327.44	46613.0
2020-01-10 08:00:00	SPY	ETF	327.43	327.59	327.09	327.4	486710.0
2020-01-10 08:30:00	SPY	ETF	327.15	327.49	326.85	327.26	472138.0
2020-01-10 09:00:00	SPY	ETF	327.28	327.44	327.1602	327.31	180774.0
2020-01-10 09:30:00	SPY	ETF	327.2899	327.44	326.573	327.16	6112959.0
2020-01-10 10:00:00	SPY	ETF	327.155	327.46	327.03	327.11	5190551.0
2020-01-10 10:30:00	SPY	ETF	327.115	327.33	326.92	327.21	3071082.0
2020-01-10 11:00:00	SPY	ETF	327.21	327.305	326.78	326.79	2234649.0
2020-01-10 11:30:00	SPY	ETF	326.79	326.88	326.415	326.565	3520986.0
2020-01-10 12:00:00	SPY	ETF	326.59	326.5901	325.93	326.42	3150294.0
2020-01-10 12:30:00	SPY	ETF	326.43	326.63	326.35	326.5	1477289.0
2020-01-10 13:00:00	SPY	ETF	326.5	326.89	326.46	326.73	1285668.0
2020-01-10 13:30:00	SPY	ETF	326.75	326.89	326.62	326.765	1278922.0
2020-01-10 14:00:00	SPY	ETF	326.76	326.8	326.29	326.37	1543971.0
2020-01-10 14:30:00	SPY	ETF	326.38	326.395	326.04	326.29	2435140.0
2020-01-10 15:00:00	SPY	ETF	326.29	326.6094	325.74	325.89	3094504.0
2020-01-10 15:30:00	SPY	ETF	325.88	325.895	325.2	325.7	10593024.0
2020-01-10 16:00:00	SPY	ETF	325.69	325.73	325.5	325.56	5791539.0
2020-01-10 16:30:00	SPY	ETF	325.56	325.71	325.45	325.46	194608.0
2020-01-10 17:00:00	SPY	ETF	325.45	325.55	325.4	325.55	78368.0
2020-01-10 17:30:00	SPY	ETF	325.6	325.6	325.45	325.57	9919.0
2020-01-10 18:00:00	SPY	ETF	325.57	325.63	325.54	325.63	6943.0
2020-01-10 18:30:00	SPY	ETF	325.56	325.62	325.52	325.62	4648.0
2020-01-10 19:00:00	SPY	ETF	325.6	325.62	325.55	325.55	2795.0
2020-01-10 19:30:00	SPY	ETF	325.55	325.6	325.49	325.6	13354.0
2020-01-10 04:00:00	QQQ	ETF	219.56	219.76	219.56	219.76	3537.0
2020-01-10 04:30:00	QQQ	ETF	219.76	219.86	219.73	219.86	3558.0
2020-01-10 05:00:00	QQQ	ETF	219.86	219.92	219.81	219.88	7350.0
2020-01-10 05:30:00	QQQ	ETF	219.91	219.91	219.88	219.88	2050.0
2020-01-10 06:00:00	QQQ	ETF	219.88	220.15	219.87	220.14	29609.0
2020-01-10 06:30:00	QQQ	ETF	220.15	220.21	220.05	220.05	19054.0
2020-01-10 07:00:00	QQQ	ETF	220.03	220.08	219.97	220.0	24227.0
2020-01-10 07:30:00	QQQ	ETF	220.0	220.08	219.98	220.03	60528.0
2020-01-10 08:00:00	QQQ	ETF	220.04	220.0702	219.57	220.03	196724.0
2020-01-10 08:30:00	QQQ	ETF	219.97	220.16	219.5	219.78	342263.0
2020-01-10 09:00:00	QQQ	ETF	219.79	219.94	219.67	219.8	206544.0
2020-01-10 09:30:00	QQQ	ETF	219.76	219.87	218.99	219.605	2644827.0
2020-01-10 10:00:00	QQQ	ETF	219.61	219.82	219.45	219.5953	1868054.0
2020-01-10 10:30:00	QQQ	ETF	219.6	219.87	219.44	219.7334	1116312.0
2020-01-10 11:00:00	QQQ	ETF	219.73	219.87	219.41	219.42	773851.0
2020-01-10 11:30:00	QQQ	ETF	219.42	219.52	219.1236	219.27	936604.0
2020-01-10 12:00:00	QQQ	ETF	219.28	219.285	218.61	219.03	1707187.0
2020-01-10 12:30:00	QQQ	ETF	219.04	219.14	218.8824	219.0087	810610.0

> showing 50 of 18,803 rows — these rows as CSV

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