PREVIEW / etf_30min / 2020-07-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-20.parquet
  size:    547 KB
  rows:    20,403

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-07-20 04:00:00	SPY	ETF	319.92	320.06	319.62	319.89	14238.0
2020-07-20 04:30:00	SPY	ETF	319.95	320.91	319.78	320.85	15844.0
2020-07-20 05:00:00	SPY	ETF	321.0	321.43	320.9	320.9	101434.0
2020-07-20 05:30:00	SPY	ETF	320.97	321.08	320.8	320.88	4916.0
2020-07-20 06:00:00	SPY	ETF	320.96	321.03	320.58	320.58	20722.0
2020-07-20 06:30:00	SPY	ETF	320.53	320.82	320.46	320.67	21037.0
2020-07-20 07:00:00	SPY	ETF	320.68	321.2	320.68	321.13	112643.0
2020-07-20 07:30:00	SPY	ETF	321.06	321.48	320.92	321.24	71791.0
2020-07-20 08:00:00	SPY	ETF	321.2	321.35	320.0	320.83	294578.0
2020-07-20 08:30:00	SPY	ETF	320.83	321.65	320.73	321.51	655087.0
2020-07-20 09:00:00	SPY	ETF	321.49	321.73	321.44	321.44	261437.0
2020-07-20 09:30:00	SPY	ETF	321.43	322.14	320.62	321.13	6444450.0
2020-07-20 10:00:00	SPY	ETF	321.145	322.65	320.93	322.63	5941923.0
2020-07-20 10:30:00	SPY	ETF	322.64	323.02	322.42	322.49	3365491.0
2020-07-20 11:00:00	SPY	ETF	322.49	322.8	322.33	322.74	1837324.0
2020-07-20 11:30:00	SPY	ETF	322.75	323.14	322.64	322.86	1801366.0
2020-07-20 12:00:00	SPY	ETF	322.86	323.09	322.46	322.74	3207895.0
2020-07-20 12:30:00	SPY	ETF	322.74	323.06	322.67	323.02	1540453.0
2020-07-20 13:00:00	SPY	ETF	323.03	323.32	322.86	323.295	1708376.0
2020-07-20 13:30:00	SPY	ETF	323.2977	323.81	323.154	323.71	2304552.0
2020-07-20 14:00:00	SPY	ETF	323.7098	323.75	323.5172	323.73	3453882.0
2020-07-20 14:30:00	SPY	ETF	323.74	323.98	323.69	323.78	1786634.0
2020-07-20 15:00:00	SPY	ETF	323.77	324.59	323.64	324.53	4103911.0
2020-07-20 15:30:00	SPY	ETF	324.53	325.13	324.29	324.36	10962959.0
2020-07-20 16:00:00	SPY	ETF	324.34	324.66	324.26	324.64	4411864.0
2020-07-20 16:30:00	SPY	ETF	324.65	324.67	324.27	324.45	298528.0
2020-07-20 17:00:00	SPY	ETF	324.45	324.49	324.3	324.3	36355.0
2020-07-20 17:30:00	SPY	ETF	324.32	324.43	324.28	324.28	23477.0
2020-07-20 18:00:00	SPY	ETF	324.32	324.62	324.27	324.27	78217.0
2020-07-20 18:30:00	SPY	ETF	324.27	324.33	324.2	324.31	24855.0
2020-07-20 19:00:00	SPY	ETF	324.3	324.49	324.3	324.47	11358.0
2020-07-20 19:30:00	SPY	ETF	324.49	324.69	324.3	324.4	38381.0
2020-07-20 04:00:00	QQQ	ETF	258.01	258.31	257.79	258.22	26017.0
2020-07-20 04:30:00	QQQ	ETF	258.25	258.78	258.19	258.76	48872.0
2020-07-20 05:00:00	QQQ	ETF	258.8	259.09	258.8	259.0	37243.0
2020-07-20 05:30:00	QQQ	ETF	258.99	259.49	258.88	259.42	20350.0
2020-07-20 06:00:00	QQQ	ETF	259.44	259.44	259.15	259.28	24575.0
2020-07-20 06:30:00	QQQ	ETF	259.13	259.39	259.07	259.37	9211.0
2020-07-20 07:00:00	QQQ	ETF	259.47	259.89	259.32	259.87	123422.0
2020-07-20 07:30:00	QQQ	ETF	259.87	260.24	259.69	259.99	64280.0
2020-07-20 08:00:00	QQQ	ETF	259.39	260.11	257.48	259.83	259673.0
2020-07-20 08:30:00	QQQ	ETF	259.8	260.37	259.8	260.25	327906.0
2020-07-20 09:00:00	QQQ	ETF	260.3	260.57	260.11	260.11	135239.0
2020-07-20 09:30:00	QQQ	ETF	260.12	260.96	258.79	260.65	4526516.0
2020-07-20 10:00:00	QQQ	ETF	260.69	262.74	260.36	262.65	3083357.0
2020-07-20 10:30:00	QQQ	ETF	262.6724	262.91	262.22	262.4	2032475.0
2020-07-20 11:00:00	QQQ	ETF	262.4	263.23	262.205	263.2	1646089.0
2020-07-20 11:30:00	QQQ	ETF	263.22	263.81	263.1	263.63	1379253.0
2020-07-20 12:00:00	QQQ	ETF	263.64	264.04	263.15	263.65	1566759.0
2020-07-20 12:30:00	QQQ	ETF	263.65	264.3	263.48	264.25	1351822.0

> showing 50 of 20,403 rows — these rows as CSV

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