PREVIEW / etf_30min / 2019-03-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-19.parquet
  size:    501 KB
  rows:    17,628

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-03-19 04:00:00	SPY	ETF	282.76	282.94	282.76	282.84	1300.0
2019-03-19 04:30:00	SPY	ETF	282.94	283.27	282.94	283.27	3036.0
2019-03-19 05:00:00	SPY	ETF	283.27	283.44	283.22	283.44	15910.0
2019-03-19 05:30:00	SPY	ETF	283.42	283.45	283.36	283.36	14595.0
2019-03-19 06:00:00	SPY	ETF	283.33	283.41	283.33	283.39	3000.0
2019-03-19 06:30:00	SPY	ETF	283.35	283.79	283.35	283.79	11235.0
2019-03-19 07:00:00	SPY	ETF	283.72	283.75	283.6	283.65	53660.0
2019-03-19 07:30:00	SPY	ETF	283.61	283.61	283.46	283.5	35062.0
2019-03-19 08:00:00	SPY	ETF	283.648	283.71	282.83	283.48	124063.0
2019-03-19 08:30:00	SPY	ETF	283.51	283.64	283.42	283.61	175950.0
2019-03-19 09:00:00	SPY	ETF	283.63	283.76	283.4	283.49	289830.0
2019-03-19 09:30:00	SPY	ETF	283.51	283.74	283.15	283.17	5825973.0
2019-03-19 10:00:00	SPY	ETF	283.175	283.79	283.17	283.279	4844939.0
2019-03-19 10:30:00	SPY	ETF	283.27	283.58	282.98	283.01	3719360.0
2019-03-19 11:00:00	SPY	ETF	283.01	283.585	283.01	283.48	2520040.0
2019-03-19 11:30:00	SPY	ETF	283.4799	284.23	283.38	284.17	4112323.0
2019-03-19 12:00:00	SPY	ETF	284.17	284.36	283.9601	283.99	3018786.0
2019-03-19 12:30:00	SPY	ETF	283.99	284.09	282.63	283.56	10655327.0
2019-03-19 13:00:00	SPY	ETF	283.57	283.68	283.3	283.45	4136420.0
2019-03-19 13:30:00	SPY	ETF	283.45	283.61	283.11	283.15	2573338.0
2019-03-19 14:00:00	SPY	ETF	283.15	283.32	282.735	283.12	2660757.0
2019-03-19 14:30:00	SPY	ETF	283.1275	283.39	282.75	282.87	2426712.0
2019-03-19 15:00:00	SPY	ETF	282.88	283.1	281.97	282.08	11063642.0
2019-03-19 15:30:00	SPY	ETF	282.09	282.51	281.41	282.48	17241228.0
2019-03-19 16:00:00	SPY	ETF	282.49	283.16	281.9793	282.09	12375671.0
2019-03-19 16:30:00	SPY	ETF	282.09	282.4	282.09	282.25	579210.0
2019-03-19 17:00:00	SPY	ETF	282.23	282.4	282.17	282.2	345762.0
2019-03-19 17:30:00	SPY	ETF	282.23	282.26	282.18	282.19	45174.0
2019-03-19 18:00:00	SPY	ETF	282.2	282.36	282.08	282.08	122514.0
2019-03-19 18:30:00	SPY	ETF	282.08	282.13	281.95	281.95	23801.0
2019-03-19 19:00:00	SPY	ETF	281.95	282.0	281.85	281.98	11748.0
2019-03-19 19:30:00	SPY	ETF	281.98	282.09	281.9	282.04	24451.0
2019-03-19 04:00:00	QQQ	ETF	178.74	178.74	178.74	178.74	1200.0
2019-03-19 04:30:00	QQQ	ETF	178.87	178.95	178.87	178.94	5200.0
2019-03-19 05:00:00	QQQ	ETF	178.93	179.03	178.9	179.03	2370.0
2019-03-19 05:30:00	QQQ	ETF	179.04	179.1	179.03	179.05	21932.0
2019-03-19 06:00:00	QQQ	ETF	179.07	179.1	179.05	179.05	8625.0
2019-03-19 06:30:00	QQQ	ETF	179.09	179.3	179.04	179.26	9150.0
2019-03-19 07:00:00	QQQ	ETF	179.25	179.27	179.16	179.17	48123.0
2019-03-19 07:30:00	QQQ	ETF	179.18	179.21	179.12	179.18	33658.0
2019-03-19 08:00:00	QQQ	ETF	179.25	179.36	178.69	179.25	76131.0
2019-03-19 08:30:00	QQQ	ETF	179.23	179.3	179.16	179.26	63401.0
2019-03-19 09:00:00	QQQ	ETF	179.26	179.38	179.14	179.18	145482.0
2019-03-19 09:30:00	QQQ	ETF	179.17	179.47	178.92	179.07	2586046.0
2019-03-19 10:00:00	QQQ	ETF	179.06	179.47	178.96	179.0195	1969695.0
2019-03-19 10:30:00	QQQ	ETF	179.015	179.26	178.87	178.8921	1826606.0
2019-03-19 11:00:00	QQQ	ETF	178.9	179.47	178.9	179.4	1411156.0
2019-03-19 11:30:00	QQQ	ETF	179.391	179.77	179.3	179.76	1911273.0
2019-03-19 12:00:00	QQQ	ETF	179.77	180.0	179.72	179.73	1694551.0
2019-03-19 12:30:00	QQQ	ETF	179.73	179.81	178.89	179.49	4508278.0

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

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