PREVIEW / etf_30min / 2020-05-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-15.parquet
  size:    533 KB
  rows:    19,775

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-05-15 04:00:00	SPY	ETF	286.34	286.45	285.86	285.91	19371.0
2020-05-15 04:30:00	SPY	ETF	285.86	286.1	285.58	285.78	6415.0
2020-05-15 05:00:00	SPY	ETF	285.98	286.15	285.65	285.77	17748.0
2020-05-15 05:30:00	SPY	ETF	285.76	285.79	285.2	285.28	15300.0
2020-05-15 06:00:00	SPY	ETF	285.4	285.75	285.05	285.39	19908.0
2020-05-15 06:30:00	SPY	ETF	285.1	285.1	283.17	283.17	247959.0
2020-05-15 07:00:00	SPY	ETF	283.32	283.37	281.97	283.2	541483.0
2020-05-15 07:30:00	SPY	ETF	283.16	283.16	281.66	281.91	599499.0
2020-05-15 08:00:00	SPY	ETF	282.4999	286.24	281.45	282.23	656501.0
2020-05-15 08:30:00	SPY	ETF	282.46	282.5	281.49	282.36	752960.0
2020-05-15 09:00:00	SPY	ETF	282.4	282.8	281.74	282.4	913165.0
2020-05-15 09:30:00	SPY	ETF	282.37	284.22	281.34	283.845	11164091.0
2020-05-15 10:00:00	SPY	ETF	283.85	285.08	283.4	284.08	7640633.0
2020-05-15 10:30:00	SPY	ETF	284.08	284.47	282.58	282.91	9414409.0
2020-05-15 11:00:00	SPY	ETF	282.91	283.31	281.89	282.91	5063658.0
2020-05-15 11:30:00	SPY	ETF	282.9	283.21	282.25	283.14	6339969.0
2020-05-15 12:00:00	SPY	ETF	283.14	284.49	282.9602	284.2	4032228.0
2020-05-15 12:30:00	SPY	ETF	284.23	284.78	283.61	284.13	6215235.0
2020-05-15 13:00:00	SPY	ETF	284.125	285.13	284.055	284.844	3875811.0
2020-05-15 13:30:00	SPY	ETF	284.865	285.14	284.135	285.0	3994604.0
2020-05-15 14:00:00	SPY	ETF	284.99	285.96	284.97	285.814	4949946.0
2020-05-15 14:30:00	SPY	ETF	285.83	285.91	284.48	284.61	5893680.0
2020-05-15 15:00:00	SPY	ETF	284.62	285.78	284.37	285.49	6137166.0
2020-05-15 15:30:00	SPY	ETF	285.47	286.33	284.58	286.26	16432625.0
2020-05-15 16:00:00	SPY	ETF	286.25	286.31	284.95	285.1202	8906122.0
2020-05-15 16:30:00	SPY	ETF	285.12	286.28	285.04	285.79	2928597.0
2020-05-15 17:00:00	SPY	ETF	285.74	286.28	285.04	285.78	2370150.0
2020-05-15 17:30:00	SPY	ETF	285.64	286.28	285.63	285.73	549883.0
2020-05-15 18:00:00	SPY	ETF	285.75	285.84	285.58	285.62	31972.0
2020-05-15 18:30:00	SPY	ETF	285.62	285.78	285.61	285.76	25128.0
2020-05-15 19:00:00	SPY	ETF	285.79	285.85	285.73	285.74	22194.0
2020-05-15 19:30:00	SPY	ETF	285.73	285.74	285.61	285.7	43807.0
2020-05-15 04:00:00	QQQ	ETF	222.97	223.04	222.66	222.77	13459.0
2020-05-15 04:30:00	QQQ	ETF	222.7	222.75	222.48	222.73	4595.0
2020-05-15 05:00:00	QQQ	ETF	222.9	222.98	222.55	222.55	2853.0
2020-05-15 05:30:00	QQQ	ETF	222.63	222.65	222.24	222.3	37568.0
2020-05-15 06:00:00	QQQ	ETF	222.37	222.72	222.15	222.5	59143.0
2020-05-15 06:30:00	QQQ	ETF	222.28	222.28	220.52	220.58	128302.0
2020-05-15 07:00:00	QQQ	ETF	220.65	220.65	219.38	220.07	407895.0
2020-05-15 07:30:00	QQQ	ETF	219.925	220.0	218.41	218.54	699142.0
2020-05-15 08:00:00	QQQ	ETF	219.1101	222.85	218.04	218.8	356636.0
2020-05-15 08:30:00	QQQ	ETF	218.63	218.78	217.98	218.56	232202.0
2020-05-15 09:00:00	QQQ	ETF	218.63	218.98	217.91	218.79	488155.0
2020-05-15 09:30:00	QQQ	ETF	218.77	220.16	218.33	220.1002	6035265.0
2020-05-15 10:00:00	QQQ	ETF	220.1	221.1	219.66	220.21	3804056.0
2020-05-15 10:30:00	QQQ	ETF	220.21	220.48	218.9	219.0968	3581362.0
2020-05-15 11:00:00	QQQ	ETF	219.08	219.66	218.4	219.31	2707487.0
2020-05-15 11:30:00	QQQ	ETF	219.3	219.61	218.83	219.575	2140132.0
2020-05-15 12:00:00	QQQ	ETF	219.565	221.0	219.4401	220.83	1991983.0
2020-05-15 12:30:00	QQQ	ETF	220.83	221.315	220.596	221.14	2982799.0

> showing 50 of 19,775 rows — these rows as CSV

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