PREVIEW / etf_30min / 2018-10-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-01.parquet
  size:    486 KB
  rows:    16,769

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-10-01 04:00:00	SPY	ETF	292.21	292.47	292.21	292.47	9676.0
2018-10-01 04:30:00	SPY	ETF	292.33	292.47	292.33	292.47	1408.0
2018-10-01 05:00:00	SPY	ETF	292.41	292.45	292.33	292.37	12688.0
2018-10-01 05:30:00	SPY	ETF	292.37	292.46	292.35	292.41	52602.0
2018-10-01 06:00:00	SPY	ETF	292.46	292.46	292.22	292.27	7732.0
2018-10-01 06:30:00	SPY	ETF	292.4	292.42	292.2	292.37	39550.0
2018-10-01 07:00:00	SPY	ETF	292.33	292.48	292.3	292.4	126276.0
2018-10-01 07:30:00	SPY	ETF	292.41	292.41	292.11	292.29	72841.0
2018-10-01 08:00:00	SPY	ETF	292.33	292.4101	292.0	292.0801	93334.0
2018-10-01 08:30:00	SPY	ETF	292.08	292.35	290.72	292.05	211903.0
2018-10-01 09:00:00	SPY	ETF	292.05	292.16	292.0	292.11	259274.0
2018-10-01 09:30:00	SPY	ETF	292.11	292.65	292.01	292.5795	6781100.0
2018-10-01 10:00:00	SPY	ETF	292.575	292.83	292.49	292.81	5319873.0
2018-10-01 10:30:00	SPY	ETF	292.82	292.93	292.52	292.68	2994780.0
2018-10-01 11:00:00	SPY	ETF	292.68	292.75	292.51	292.57	2301608.0
2018-10-01 11:30:00	SPY	ETF	292.57	292.73	292.35	292.52	1843623.0
2018-10-01 12:00:00	SPY	ETF	292.52	292.535	291.92	292.1199	3392089.0
2018-10-01 12:30:00	SPY	ETF	292.115	292.1686	291.86	291.98	2213613.0
2018-10-01 13:00:00	SPY	ETF	291.975	292.2	291.91	292.16	2926509.0
2018-10-01 13:30:00	SPY	ETF	292.17	292.26	291.98	292.04	2207445.0
2018-10-01 14:00:00	SPY	ETF	292.04	292.05	291.72	292.025	2661046.0
2018-10-01 14:30:00	SPY	ETF	292.03	292.035	291.67	291.985	3110523.0
2018-10-01 15:00:00	SPY	ETF	291.98	292.08	291.34	291.44	6169303.0
2018-10-01 15:30:00	SPY	ETF	291.45	291.74	290.98	291.67	11950310.0
2018-10-01 16:00:00	SPY	ETF	291.68	291.77	291.49	291.71	5749589.0
2018-10-01 16:30:00	SPY	ETF	291.74	291.81	291.61	291.67	103907.0
2018-10-01 17:00:00	SPY	ETF	291.7	291.73	291.66	291.67	42564.0
2018-10-01 17:30:00	SPY	ETF	291.68	291.7	291.67	291.7	14843.0
2018-10-01 18:00:00	SPY	ETF	291.68	291.75	291.6	291.64	42224.0
2018-10-01 18:30:00	SPY	ETF	291.68	291.73	291.61	291.7	5625.0
2018-10-01 19:00:00	SPY	ETF	291.6601	291.7	291.63	291.66	19287.0
2018-10-01 19:30:00	SPY	ETF	291.65	291.75	291.65	291.69	6898.0
2018-10-01 04:00:00	QQQ	ETF	186.8	187.23	186.8	187.2	15115.0
2018-10-01 04:30:00	QQQ	ETF	187.18	187.18	187.13	187.17	10830.0
2018-10-01 05:00:00	QQQ	ETF	187.21	187.27	187.13	187.15	24400.0
2018-10-01 05:30:00	QQQ	ETF	187.28	187.32	187.24	187.31	7300.0
2018-10-01 06:00:00	QQQ	ETF	187.31	187.31	187.16	187.16	6650.0
2018-10-01 06:30:00	QQQ	ETF	187.29	187.29	187.15	187.18	7400.0
2018-10-01 07:00:00	QQQ	ETF	187.11	187.19	187.05	187.14	54668.0
2018-10-01 07:30:00	QQQ	ETF	187.09	187.11	186.95	187.0	49702.0
2018-10-01 08:00:00	QQQ	ETF	187.0799	187.16	186.88	186.9	82864.0
2018-10-01 08:30:00	QQQ	ETF	186.88	186.89	185.79	186.85	167269.0
2018-10-01 09:00:00	QQQ	ETF	186.83	186.94	186.8	186.84	86982.0
2018-10-01 09:30:00	QQQ	ETF	186.82	187.46	186.65	187.32	3417317.0
2018-10-01 10:00:00	QQQ	ETF	187.33	187.53	187.16	187.439	1703198.0
2018-10-01 10:30:00	QQQ	ETF	187.44	187.5	187.11	187.3	1424607.0
2018-10-01 11:00:00	QQQ	ETF	187.31	187.31	187.11	187.24	1217827.0
2018-10-01 11:30:00	QQQ	ETF	187.24	187.3	186.88	187.05	1013605.0
2018-10-01 12:00:00	QQQ	ETF	187.05	187.08	186.68	186.79	1190705.0
2018-10-01 12:30:00	QQQ	ETF	186.78	186.8	186.42	186.51	1818417.0

> showing 50 of 16,769 rows — these rows as CSV

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