PREVIEW / etf_30min / 2020-03-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-30.parquet
  size:    584 KB
  rows:    21,471

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-30 04:00:00	SPY	ETF	250.25	252.08	250.2	251.6	252563.0
2020-03-30 04:30:00	SPY	ETF	251.51	253.66	251.34	252.46	133737.0
2020-03-30 05:00:00	SPY	ETF	252.55	253.82	251.24	253.75	75274.0
2020-03-30 05:30:00	SPY	ETF	253.74	253.89	251.75	251.94	115271.0
2020-03-30 06:00:00	SPY	ETF	251.93	253.72	251.93	252.73	218579.0
2020-03-30 06:30:00	SPY	ETF	252.98	253.81	252.5	253.5	198154.0
2020-03-30 07:00:00	SPY	ETF	253.44	254.2	252.8	253.68	540561.0
2020-03-30 07:30:00	SPY	ETF	253.64	254.26	252.6	253.8	703444.0
2020-03-30 08:00:00	SPY	ETF	253.7101	256.96	250.09	254.5699	1016444.0
2020-03-30 08:30:00	SPY	ETF	254.57	256.25	254.46	256.25	1100299.0
2020-03-30 09:00:00	SPY	ETF	256.26	256.58	255.17	255.71	1217923.0
2020-03-30 09:30:00	SPY	ETF	255.7	257.24	253.53	255.31	14588925.0
2020-03-30 10:00:00	SPY	ETF	255.3	257.53	254.74	256.77	11217520.0
2020-03-30 10:30:00	SPY	ETF	256.775	258.56	256.56	257.0761	8931409.0
2020-03-30 11:00:00	SPY	ETF	257.07	259.73	256.81	259.65	9401443.0
2020-03-30 11:30:00	SPY	ETF	259.67	259.87	258.7599	259.16	9000930.0
2020-03-30 12:00:00	SPY	ETF	259.17	260.0	258.12	259.94	7339857.0
2020-03-30 12:30:00	SPY	ETF	259.91	260.38	259.07	260.32	6238715.0
2020-03-30 13:00:00	SPY	ETF	260.33	260.33	259.1	259.84	7426619.0
2020-03-30 13:30:00	SPY	ETF	259.87	260.03	258.57	259.0919	8092832.0
2020-03-30 14:00:00	SPY	ETF	259.09	259.63	257.94	259.49	8537100.0
2020-03-30 14:30:00	SPY	ETF	259.51	260.95	259.24	260.32	8986859.0
2020-03-30 15:00:00	SPY	ETF	260.32	261.84	258.92	259.91	15605174.0
2020-03-30 15:30:00	SPY	ETF	259.94	262.43	259.55	261.68	23728599.0
2020-03-30 16:00:00	SPY	ETF	261.63	261.821	260.87	261.44	19701009.0
2020-03-30 16:30:00	SPY	ETF	261.44	262.25	261.22	261.69	3455285.0
2020-03-30 17:00:00	SPY	ETF	261.63	262.0	261.55	261.94	98407.0
2020-03-30 17:30:00	SPY	ETF	261.9	261.9	261.5	261.57	251124.0
2020-03-30 18:00:00	SPY	ETF	261.56	262.29	261.34	262.29	145890.0
2020-03-30 18:30:00	SPY	ETF	262.29	262.6	261.71	261.95	173262.0
2020-03-30 19:00:00	SPY	ETF	261.78	261.93	261.29	261.56	132361.0
2020-03-30 19:30:00	SPY	ETF	261.52	262.23	261.51	261.93	230501.0
2020-03-30 04:00:00	QQQ	ETF	183.32	184.52	183.19	184.06	53711.0
2020-03-30 04:30:00	QQQ	ETF	184.04	185.44	184.04	184.69	63211.0
2020-03-30 05:00:00	QQQ	ETF	185.0	185.87	184.14	185.8	56935.0
2020-03-30 05:30:00	QQQ	ETF	185.66	186.07	184.5	184.57	43648.0
2020-03-30 06:00:00	QQQ	ETF	184.61	185.59	184.61	185.08	82863.0
2020-03-30 06:30:00	QQQ	ETF	185.06	185.85	184.87	185.59	85613.0
2020-03-30 07:00:00	QQQ	ETF	185.56	186.15	185.11	185.75	118973.0
2020-03-30 07:30:00	QQQ	ETF	185.75	186.09	185.08	185.71	111623.0
2020-03-30 08:00:00	QQQ	ETF	185.54	187.4	183.5	186.4	167291.0
2020-03-30 08:30:00	QQQ	ETF	186.37	187.5	186.32	187.5	202631.0
2020-03-30 09:00:00	QQQ	ETF	187.5	187.63	186.76	187.15	401742.0
2020-03-30 09:30:00	QQQ	ETF	187.1	188.34	186.3406	187.73	4983758.0
2020-03-30 10:00:00	QQQ	ETF	187.72	189.63	187.43	189.12	4610967.0
2020-03-30 10:30:00	QQQ	ETF	189.14	190.36	189.01	189.58	3063061.0
2020-03-30 11:00:00	QQQ	ETF	189.55	190.99	189.38	190.98	2366371.0
2020-03-30 11:30:00	QQQ	ETF	191.0	191.16	190.39	190.59	2180552.0
2020-03-30 12:00:00	QQQ	ETF	190.59	191.08	189.745	191.02	2189206.0
2020-03-30 12:30:00	QQQ	ETF	191.03	191.61	190.6	191.58	1923960.0

> showing 50 of 21,471 rows — these rows as CSV

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