PREVIEW / etf_30min / 2020-11-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-10.parquet
  size:    599 KB
  rows:    22,483

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-11-10 04:00:00	SPY	ETF	354.42	355.35	354.28	355.35	91483.0
2020-11-10 04:30:00	SPY	ETF	355.23	355.77	354.95	355.19	38802.0
2020-11-10 05:00:00	SPY	ETF	355.12	355.18	352.98	353.11	56795.0
2020-11-10 05:30:00	SPY	ETF	353.09	353.81	352.4	352.45	122924.0
2020-11-10 06:00:00	SPY	ETF	352.26	353.56	351.96	353.15	114468.0
2020-11-10 06:30:00	SPY	ETF	353.06	354.44	353.04	354.38	124011.0
2020-11-10 07:00:00	SPY	ETF	354.41	355.0	353.39	353.96	330833.0
2020-11-10 07:30:00	SPY	ETF	354.04	354.3	353.4	353.47	189300.0
2020-11-10 08:00:00	SPY	ETF	353.6801	355.05	351.69	353.85	231376.0
2020-11-10 08:30:00	SPY	ETF	353.85	353.95	352.81	353.37	297866.0
2020-11-10 09:00:00	SPY	ETF	353.3	353.89	352.9	353.44	417126.0
2020-11-10 09:30:00	SPY	ETF	353.49	354.41	351.92	353.56	8261559.0
2020-11-10 10:00:00	SPY	ETF	353.58	354.5699	352.44	352.49	5197872.0
2020-11-10 10:30:00	SPY	ETF	352.49	352.675	350.51	351.6719	5688358.0
2020-11-10 11:00:00	SPY	ETF	351.65	353.62	351.57	353.55	5244992.0
2020-11-10 11:30:00	SPY	ETF	353.54	354.25	352.853	353.58	4129713.0
2020-11-10 12:00:00	SPY	ETF	353.57	355.18	353.48	354.3466	4123824.0
2020-11-10 12:30:00	SPY	ETF	354.34	354.77	353.64	354.27	3444646.0
2020-11-10 13:00:00	SPY	ETF	354.26	354.7	352.62	352.88	4176824.0
2020-11-10 13:30:00	SPY	ETF	352.86	354.16	352.22	354.08	3550885.0
2020-11-10 14:00:00	SPY	ETF	354.07	354.58	352.86	353.22	5838363.0
2020-11-10 14:30:00	SPY	ETF	353.24	354.624	353.14	353.99	4777172.0
2020-11-10 15:00:00	SPY	ETF	353.97	354.81	353.27	354.65	4861957.0
2020-11-10 15:30:00	SPY	ETF	354.635	354.77	353.49	354.07	12106590.0
2020-11-10 16:00:00	SPY	ETF	354.0601	354.68	353.9437	354.34	8766552.0
2020-11-10 16:30:00	SPY	ETF	354.32	354.63	353.579	354.47	919909.0
2020-11-10 17:00:00	SPY	ETF	354.47	354.51	354.36	354.36	27411.0
2020-11-10 17:30:00	SPY	ETF	354.48	354.49	354.2	354.4	630692.0
2020-11-10 18:00:00	SPY	ETF	354.46	355.07	354.27	354.7	169241.0
2020-11-10 18:30:00	SPY	ETF	354.57	354.66	353.42	353.68	98208.0
2020-11-10 19:00:00	SPY	ETF	353.62	353.94	353.02	353.49	100408.0
2020-11-10 19:30:00	SPY	ETF	353.5	353.85	353.3	353.52	55149.0
2020-11-10 04:00:00	QQQ	ETF	287.49	287.64	285.8	286.57	79825.0
2020-11-10 04:30:00	QQQ	ETF	286.57	287.1	285.99	286.09	32189.0
2020-11-10 05:00:00	QQQ	ETF	286.11	286.49	284.68	284.93	91419.0
2020-11-10 05:30:00	QQQ	ETF	284.84	285.2	282.2	282.28	341332.0
2020-11-10 06:00:00	QQQ	ETF	282.29	283.07	281.93	282.9	210938.0
2020-11-10 06:30:00	QQQ	ETF	282.93	284.4	282.76	284.22	216494.0
2020-11-10 07:00:00	QQQ	ETF	284.24	284.91	283.29	283.91	628505.0
2020-11-10 07:30:00	QQQ	ETF	283.9	284.57	283.47	283.47	390103.0
2020-11-10 08:00:00	QQQ	ETF	284.0	289.11	282.21	284.34	401764.0
2020-11-10 08:30:00	QQQ	ETF	284.38	284.74	283.44	284.65	531369.0
2020-11-10 09:00:00	QQQ	ETF	284.64	285.35	284.38	285.21	630434.0
2020-11-10 09:30:00	QQQ	ETF	285.27	286.6599	283.3	284.22	6034927.0
2020-11-10 10:00:00	QQQ	ETF	284.2	285.17	282.06	282.075	4782696.0
2020-11-10 10:30:00	QQQ	ETF	282.06	282.65	280.62	282.23	5304868.0
2020-11-10 11:00:00	QQQ	ETF	282.22	284.3772	282.0664	284.34	3659071.0
2020-11-10 11:30:00	QQQ	ETF	284.33	285.96	283.81	284.43	2764818.0
2020-11-10 12:00:00	QQQ	ETF	284.436	286.49	284.4	285.154	2541558.0
2020-11-10 12:30:00	QQQ	ETF	285.09	285.87	284.47	285.33	1744293.0

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

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