PREVIEW / etf_30min / 2019-04-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-09.parquet
  size:    489 KB
  rows:    17,155

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
2019-04-09 04:00:00	SPY	ETF	288.48	288.49	288.4	288.46	3570.0
2019-04-09 04:30:00	SPY	ETF	288.41	288.63	288.4	288.63	2850.0
2019-04-09 05:00:00	SPY	ETF	288.63	288.63	288.55	288.55	1200.0
2019-04-09 05:30:00	SPY	ETF	288.66	288.7	288.63	288.63	1025.0
2019-04-09 06:30:00	SPY	ETF	288.58	288.58	288.5	288.5	3500.0
2019-04-09 07:00:00	SPY	ETF	288.6	288.61	288.5	288.56	45928.0
2019-04-09 07:30:00	SPY	ETF	288.6	288.64	288.46	288.46	130738.0
2019-04-09 08:00:00	SPY	ETF	288.49	288.61	288.19	288.19	1908916.0
2019-04-09 08:30:00	SPY	ETF	288.18	288.21	288.03	288.05	221716.0
2019-04-09 09:00:00	SPY	ETF	288.05	288.13	287.7	287.7	313948.0
2019-04-09 09:30:00	SPY	ETF	287.72	287.78	286.99	287.45	8065204.0
2019-04-09 10:00:00	SPY	ETF	287.46	287.6764	287.17	287.58	4064787.0
2019-04-09 10:30:00	SPY	ETF	287.5799	287.81	287.14	287.52	4845521.0
2019-04-09 11:00:00	SPY	ETF	287.53	287.79	287.4	287.54	3287636.0
2019-04-09 11:30:00	SPY	ETF	287.55	287.755	287.38	287.59	4295180.0
2019-04-09 12:00:00	SPY	ETF	287.58	288.08	287.52	287.945	4356321.0
2019-04-09 12:30:00	SPY	ETF	287.94	287.99	287.67	287.68	1498807.0
2019-04-09 13:00:00	SPY	ETF	287.6715	287.6715	287.42	287.44	2094955.0
2019-04-09 13:30:00	SPY	ETF	287.445	287.525	287.24	287.35	2097794.0
2019-04-09 14:00:00	SPY	ETF	287.35	287.4	287.0865	287.18	3104417.0
2019-04-09 14:30:00	SPY	ETF	287.18	287.37	286.93	287.04	4182396.0
2019-04-09 15:00:00	SPY	ETF	287.042	287.5718	286.8412	286.95	3422080.0
2019-04-09 15:30:00	SPY	ETF	286.96	287.37	286.7	287.305	11500667.0
2019-04-09 16:00:00	SPY	ETF	287.3	287.36	287.03	287.23	5026296.0
2019-04-09 16:30:00	SPY	ETF	287.21	287.23	287.09	287.18	115865.0
2019-04-09 17:00:00	SPY	ETF	287.16	287.2	287.11	287.16	23685.0
2019-04-09 17:30:00	SPY	ETF	287.15	287.16	287.1	287.12	13122.0
2019-04-09 18:00:00	SPY	ETF	287.14	287.24	287.13	287.16	29647.0
2019-04-09 18:30:00	SPY	ETF	287.17	287.18	287.12	287.14	4954.0
2019-04-09 19:00:00	SPY	ETF	287.14	287.21	287.14	287.1966	7225.0
2019-04-09 19:30:00	SPY	ETF	287.13	287.15	287.01	287.12	19169.0
2019-04-09 04:00:00	QQQ	ETF	184.92	184.92	184.88	184.91	6830.0
2019-04-09 04:30:00	QQQ	ETF	184.98	185.05	184.9	184.9	20487.0
2019-04-09 05:00:00	QQQ	ETF	184.86	184.94	184.8	184.86	45700.0
2019-04-09 05:30:00	QQQ	ETF	184.98	185.0	184.97	184.97	13450.0
2019-04-09 06:00:00	QQQ	ETF	184.96	184.97	184.9	184.92	3850.0
2019-04-09 06:30:00	QQQ	ETF	184.92	184.92	184.88	184.91	2300.0
2019-04-09 07:00:00	QQQ	ETF	184.93	185.02	184.85	184.97	58214.0
2019-04-09 07:30:00	QQQ	ETF	184.97	185.01	184.9	184.93	46417.0
2019-04-09 08:00:00	QQQ	ETF	184.89	185.11	184.65	184.65	188444.0
2019-04-09 08:30:00	QQQ	ETF	184.66	184.76	184.58	184.7	96598.0
2019-04-09 09:00:00	QQQ	ETF	184.67	184.76	184.45	184.49	167716.0
2019-04-09 09:30:00	QQQ	ETF	184.5	184.84	184.22	184.75	3286521.0
2019-04-09 10:00:00	QQQ	ETF	184.76	185.0155	184.57	184.99	2252345.0
2019-04-09 10:30:00	QQQ	ETF	185.0	185.1	184.4937	184.79	2975198.0
2019-04-09 11:00:00	QQQ	ETF	184.8	185.03	184.68	184.76	1239577.0
2019-04-09 11:30:00	QQQ	ETF	184.77	184.96	184.67	184.82	1127864.0
2019-04-09 12:00:00	QQQ	ETF	184.82	185.11	184.77	185.0	826568.0
2019-04-09 12:30:00	QQQ	ETF	185.0	185.08	184.85	184.86	549988.0
2019-04-09 13:00:00	QQQ	ETF	184.85	184.86	184.5401	184.57	753396.0

> showing 50 of 17,155 rows — these rows as CSV

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