PREVIEW / etf_30min / 2020-04-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-08.parquet
  size:    571 KB
  rows:    20,989

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-04-08 04:00:00	SPY	ETF	265.8	265.88	263.85	263.85	93861.0
2020-04-08 04:30:00	SPY	ETF	263.71	264.26	263.03	264.12	48769.0
2020-04-08 05:00:00	SPY	ETF	264.1	264.45	263.61	264.06	31635.0
2020-04-08 05:30:00	SPY	ETF	264.34	264.78	263.51	264.03	57151.0
2020-04-08 06:00:00	SPY	ETF	264.04	265.1	263.85	265.1	54408.0
2020-04-08 06:30:00	SPY	ETF	265.0	265.87	264.84	265.73	85480.0
2020-04-08 07:00:00	SPY	ETF	265.71	266.96	265.39	266.32	264630.0
2020-04-08 07:30:00	SPY	ETF	266.28	266.67	265.5	266.66	308078.0
2020-04-08 08:00:00	SPY	ETF	266.6	267.87	263.34	267.33	692671.0
2020-04-08 08:30:00	SPY	ETF	267.31	267.95	266.68	267.3	575527.0
2020-04-08 09:00:00	SPY	ETF	267.26	268.61	267.25	267.99	778082.0
2020-04-08 09:30:00	SPY	ETF	267.96	269.0	266.25	266.48	11970705.0
2020-04-08 10:00:00	SPY	ETF	266.485	267.98	265.56	267.86	8139702.0
2020-04-08 10:30:00	SPY	ETF	267.854	269.0	267.08	268.92	8361141.0
2020-04-08 11:00:00	SPY	ETF	268.95	270.85	268.32	270.54	8909179.0
2020-04-08 11:30:00	SPY	ETF	270.56	271.72	270.31	270.79	8026499.0
2020-04-08 12:00:00	SPY	ETF	270.795	271.64	270.24	270.95	7364140.0
2020-04-08 12:30:00	SPY	ETF	270.96	272.37	270.73	271.5	9553126.0
2020-04-08 13:00:00	SPY	ETF	271.5	272.15	271.06	271.41	6699822.0
2020-04-08 13:30:00	SPY	ETF	271.43	271.6	270.06	270.31	8250795.0
2020-04-08 14:00:00	SPY	ETF	270.305	272.94	270.18	272.7901	10026600.0
2020-04-08 14:30:00	SPY	ETF	272.815	273.82	272.69	273.755	8492378.0
2020-04-08 15:00:00	SPY	ETF	273.77	274.41	273.06	273.83	10700226.0
2020-04-08 15:30:00	SPY	ETF	273.85	276.0	272.15	274.07	30384615.0
2020-04-08 16:00:00	SPY	ETF	274.1	274.49	273.65	273.66	9537518.0
2020-04-08 16:30:00	SPY	ETF	273.79	274.41	273.78	274.2	747645.0
2020-04-08 17:00:00	SPY	ETF	274.15	274.32	273.88	274.0	153239.0
2020-04-08 17:30:00	SPY	ETF	273.97	274.0	273.7	273.92	129716.0
2020-04-08 18:00:00	SPY	ETF	273.93	274.03	273.06	273.49	396882.0
2020-04-08 18:30:00	SPY	ETF	273.5	273.7	273.32	273.59	122636.0
2020-04-08 19:00:00	SPY	ETF	273.56	274.91	273.26	274.83	236018.0
2020-04-08 19:30:00	SPY	ETF	274.85	275.29	274.3	274.99	328923.0
2020-04-08 04:00:00	QQQ	ETF	196.56	196.6	195.49	195.5	51707.0
2020-04-08 04:30:00	QQQ	ETF	195.36	195.66	194.86	195.62	54184.0
2020-04-08 05:00:00	QQQ	ETF	195.75	195.83	195.31	195.74	38900.0
2020-04-08 05:30:00	QQQ	ETF	195.84	196.16	195.28	195.61	67656.0
2020-04-08 06:00:00	QQQ	ETF	195.64	196.35	195.56	196.35	43277.0
2020-04-08 06:30:00	QQQ	ETF	196.25	196.93	196.24	196.91	93611.0
2020-04-08 07:00:00	QQQ	ETF	196.91	197.77	196.61	197.33	100108.0
2020-04-08 07:30:00	QQQ	ETF	197.25	197.54	196.66	197.52	106791.0
2020-04-08 08:00:00	QQQ	ETF	197.4	198.34	195.31	197.93	169578.0
2020-04-08 08:30:00	QQQ	ETF	197.96	198.25	197.25	197.68	210677.0
2020-04-08 09:00:00	QQQ	ETF	197.73	198.6	197.73	198.08	210642.0
2020-04-08 09:30:00	QQQ	ETF	198.1	199.03	196.85	197.02	4556357.0
2020-04-08 10:00:00	QQQ	ETF	197.03	197.785	196.37	197.73	3157620.0
2020-04-08 10:30:00	QQQ	ETF	197.74	198.63	197.27	198.52	2540858.0
2020-04-08 11:00:00	QQQ	ETF	198.54	199.47	197.99	199.36	2796742.0
2020-04-08 11:30:00	QQQ	ETF	199.35	199.88	199.11	199.165	2210636.0
2020-04-08 12:00:00	QQQ	ETF	199.19	199.6	198.86	199.0718	1837280.0
2020-04-08 12:30:00	QQQ	ETF	199.09	200.01	198.9	199.49	2438437.0

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

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