PREVIEW / etf_30min / 2020-03-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-26.parquet
  size:    616 KB
  rows:    22,702

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-03-26 04:00:00	SPY	ETF	242.23	243.85	241.12	241.88	186538.0
2020-03-26 04:30:00	SPY	ETF	241.89	242.77	241.43	242.77	95168.0
2020-03-26 05:00:00	SPY	ETF	242.85	243.73	241.96	242.38	110805.0
2020-03-26 05:30:00	SPY	ETF	242.25	243.75	242.03	243.37	176634.0
2020-03-26 06:00:00	SPY	ETF	243.37	244.01	242.9	244.0	192058.0
2020-03-26 06:30:00	SPY	ETF	244.29	245.35	244.0	244.36	215763.0
2020-03-26 07:00:00	SPY	ETF	244.45	244.75	243.89	243.96	768229.0
2020-03-26 07:30:00	SPY	ETF	243.93	244.33	242.11	242.3	715852.0
2020-03-26 08:00:00	SPY	ETF	242.41	246.9	240.91	241.0	1449562.0
2020-03-26 08:30:00	SPY	ETF	241.0	246.7	240.33	246.1	3700669.0
2020-03-26 09:00:00	SPY	ETF	246.1	249.84	245.16	249.53	3105569.0
2020-03-26 09:30:00	SPY	ETF	249.52	254.14	249.05	253.71	25110407.0
2020-03-26 10:00:00	SPY	ETF	253.71	257.5	252.82	255.4	24635150.0
2020-03-26 10:30:00	SPY	ETF	255.37	257.4	253.92	255.56	17640044.0
2020-03-26 11:00:00	SPY	ETF	255.58	257.77	254.36	257.5155	15837785.0
2020-03-26 11:30:00	SPY	ETF	257.51	259.03	257.27	258.4	14444320.0
2020-03-26 12:00:00	SPY	ETF	258.48	259.01	256.62	258.3205	11340670.0
2020-03-26 12:30:00	SPY	ETF	258.34	259.18	257.43	258.72	9694833.0
2020-03-26 13:00:00	SPY	ETF	258.72	259.36	255.5203	256.11	14708990.0
2020-03-26 13:30:00	SPY	ETF	256.1	257.66	254.82	256.75	10243376.0
2020-03-26 14:00:00	SPY	ETF	256.73	257.43	255.46	256.9766	9634161.0
2020-03-26 14:30:00	SPY	ETF	256.99	259.09	256.98	258.5601	11536106.0
2020-03-26 15:00:00	SPY	ETF	258.57	258.72	256.94	258.68	12551361.0
2020-03-26 15:30:00	SPY	ETF	258.68	262.8	256.54	261.39	44349827.0
2020-03-26 16:00:00	SPY	ETF	261.4	262.122	260.29	260.97	18738081.0
2020-03-26 16:30:00	SPY	ETF	260.97	262.15	260.97	262.15	1005603.0
2020-03-26 17:00:00	SPY	ETF	262.17	262.24	261.2	262.17	380205.0
2020-03-26 17:30:00	SPY	ETF	262.16	262.79	262.0	262.77	255799.0
2020-03-26 18:00:00	SPY	ETF	262.76	263.0	261.14	261.72	624825.0
2020-03-26 18:30:00	SPY	ETF	261.73	262.29	260.69	260.7	274735.0
2020-03-26 19:00:00	SPY	ETF	260.75	262.13	260.34	261.83	239956.0
2020-03-26 19:30:00	SPY	ETF	261.83	263.7	261.3	263.35	383345.0
2020-03-26 04:00:00	QQQ	ETF	179.51	180.61	179.08	179.25	70462.0
2020-03-26 04:30:00	QQQ	ETF	179.4	179.85	178.98	179.74	33436.0
2020-03-26 05:00:00	QQQ	ETF	179.94	180.39	179.1	179.32	123052.0
2020-03-26 05:30:00	QQQ	ETF	179.5	180.19	179.15	180.06	94904.0
2020-03-26 06:00:00	QQQ	ETF	180.02	180.6	179.79	180.54	45415.0
2020-03-26 06:30:00	QQQ	ETF	180.54	181.45	180.52	180.9	97381.0
2020-03-26 07:00:00	QQQ	ETF	180.96	181.51	180.61	181.12	153588.0
2020-03-26 07:30:00	QQQ	ETF	181.0	181.3	179.58	179.74	186321.0
2020-03-26 08:00:00	QQQ	ETF	179.69	181.99	178.6702	179.14	312268.0
2020-03-26 08:30:00	QQQ	ETF	178.83	182.5	178.6	182.23	735168.0
2020-03-26 09:00:00	QQQ	ETF	182.27	184.18	181.7	183.86	495620.0
2020-03-26 09:30:00	QQQ	ETF	183.83	186.77	183.61	186.29	7792221.0
2020-03-26 10:00:00	QQQ	ETF	186.28	188.21	185.8079	187.0	5249842.0
2020-03-26 10:30:00	QQQ	ETF	186.99	188.46	186.15	187.36	4932081.0
2020-03-26 11:00:00	QQQ	ETF	187.36	188.55	186.57	188.39	4007630.0
2020-03-26 11:30:00	QQQ	ETF	188.39	189.21	188.14	188.85	4244075.0
2020-03-26 12:00:00	QQQ	ETF	188.92	189.28	187.7701	188.88	2926624.0
2020-03-26 12:30:00	QQQ	ETF	188.87	189.61	188.46	189.38	2864821.0

> showing 50 of 22,702 rows — these rows as CSV

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