PREVIEW / etf_30min / 2018-01-31

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-31.parquet
  size:    496 KB
  rows:    17,165

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
2018-01-31 04:00:00	SPY	ETF	282.85	283.0	282.68	282.68	16610.0
2018-01-31 04:30:00	SPY	ETF	282.68	282.68	282.46	282.56	2460.0
2018-01-31 05:00:00	SPY	ETF	282.59	282.62	282.27	282.27	2601.0
2018-01-31 05:30:00	SPY	ETF	282.41	282.56	282.41	282.56	11700.0
2018-01-31 06:00:00	SPY	ETF	282.5	282.78	282.5	282.66	5000.0
2018-01-31 06:30:00	SPY	ETF	282.63	282.65	282.4	282.65	32010.0
2018-01-31 07:00:00	SPY	ETF	282.65	282.99	282.62	282.99	219013.0
2018-01-31 07:30:00	SPY	ETF	282.93	283.25	282.9	283.25	242915.0
2018-01-31 08:00:00	SPY	ETF	283.25	283.25	281.76	283.02	307760.0
2018-01-31 08:30:00	SPY	ETF	283.0	283.02	282.75	282.78	496560.0
2018-01-31 09:00:00	SPY	ETF	282.78	282.79	282.51	282.72	522032.0
2018-01-31 09:30:00	SPY	ETF	282.73	283.3	282.56	282.8	7280529.0
2018-01-31 10:00:00	SPY	ETF	282.79	283.06	282.41	282.74	5452050.0
2018-01-31 10:30:00	SPY	ETF	282.74	282.85	282.01	282.28	5614161.0
2018-01-31 11:00:00	SPY	ETF	282.28	282.32	281.88	281.8943	3395485.0
2018-01-31 11:30:00	SPY	ETF	281.89	282.29	281.87	281.9	3867568.0
2018-01-31 12:00:00	SPY	ETF	281.89	282.26	281.82	282.1485	1943662.0
2018-01-31 12:30:00	SPY	ETF	282.15	282.36	282.095	282.25	5401608.0
2018-01-31 13:00:00	SPY	ETF	282.26	282.58	282.2	282.525	2989689.0
2018-01-31 13:30:00	SPY	ETF	282.52	282.58	282.2	282.25	2740056.0
2018-01-31 14:00:00	SPY	ETF	282.26	282.79	281.48	281.6268	7287117.0
2018-01-31 14:30:00	SPY	ETF	281.6275	281.79	280.69	281.27	9446583.0
2018-01-31 15:00:00	SPY	ETF	281.27	281.49	280.68	281.4475	12260532.0
2018-01-31 15:30:00	SPY	ETF	281.445	282.52	281.4	281.91	24902997.0
2018-01-31 16:00:00	SPY	ETF	281.9	282.3	281.7037	282.25	12272578.0
2018-01-31 16:30:00	SPY	ETF	282.23	282.24	281.9	281.98	6676913.0
2018-01-31 17:00:00	SPY	ETF	281.96	282.06	281.9	282.05	610093.0
2018-01-31 17:30:00	SPY	ETF	282.04	282.4	282.04	282.35	102727.0
2018-01-31 18:00:00	SPY	ETF	282.3	282.8	281.9	282.72	90581.0
2018-01-31 18:30:00	SPY	ETF	282.73	282.75	282.42	282.5	29988.0
2018-01-31 19:00:00	SPY	ETF	282.54	282.72	282.5	282.7	53810.0
2018-01-31 19:30:00	SPY	ETF	282.67	282.71	282.45	282.54	27821.0
2018-01-31 20:00:00	SPY	ETF	281.7803	281.9	281.7803	281.9	85172.0
2018-01-31 04:00:00	QQQ	ETF	169.26	169.33	169.2	169.22	12698.0
2018-01-31 04:30:00	QQQ	ETF	169.14	169.19	169.08	169.19	25811.0
2018-01-31 05:00:00	QQQ	ETF	169.16	169.16	169.03	169.07	9704.0
2018-01-31 05:30:00	QQQ	ETF	169.1	169.18	169.1	169.18	2800.0
2018-01-31 06:00:00	QQQ	ETF	169.21	169.37	169.21	169.22	21810.0
2018-01-31 06:30:00	QQQ	ETF	169.21	169.27	169.08	169.27	13695.0
2018-01-31 07:00:00	QQQ	ETF	169.25	169.4	169.22	169.4	77013.0
2018-01-31 07:30:00	QQQ	ETF	169.44	169.59	169.36	169.58	60063.0
2018-01-31 08:00:00	QQQ	ETF	168.96	169.7	168.96	169.58	325040.0
2018-01-31 08:30:00	QQQ	ETF	169.56	169.7	169.47	169.62	109412.0
2018-01-31 09:00:00	QQQ	ETF	169.61	169.69	168.7	169.66	218930.0
2018-01-31 09:30:00	QQQ	ETF	169.67	169.9899	169.6	169.73	2898248.0
2018-01-31 10:00:00	QQQ	ETF	169.71	169.89	169.48	169.77	1914150.0
2018-01-31 10:30:00	QQQ	ETF	169.77	169.9	169.3	169.44	2598000.0
2018-01-31 11:00:00	QQQ	ETF	169.445	169.495	169.07	169.08	2383197.0
2018-01-31 11:30:00	QQQ	ETF	169.08	169.3699	168.94	168.96	1179926.0
2018-01-31 12:00:00	QQQ	ETF	168.97	169.45	168.8862	169.3645	1683496.0

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

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