PREVIEW / etf_30min / 2018-08-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-15.parquet
  size:    493 KB
  rows:    16,922

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-08-15 04:00:00	SPY	ETF	283.7	283.71	283.5	283.71	7003.0
2018-08-15 04:30:00	SPY	ETF	283.66	283.68	283.55	283.55	2620.0
2018-08-15 05:00:00	SPY	ETF	283.58	283.59	283.44	283.44	7303.0
2018-08-15 05:30:00	SPY	ETF	283.41	283.41	283.2	283.22	5252.0
2018-08-15 06:00:00	SPY	ETF	283.2	283.29	282.86	282.99	43414.0
2018-08-15 06:30:00	SPY	ETF	282.94	282.96	282.35	282.4	187039.0
2018-08-15 07:00:00	SPY	ETF	282.47	282.7	282.25	282.47	358041.0
2018-08-15 07:30:00	SPY	ETF	282.47	282.47	282.0	282.41	381213.0
2018-08-15 08:00:00	SPY	ETF	282.39	283.38	282.0501	282.62	254392.0
2018-08-15 08:30:00	SPY	ETF	282.54	282.54	282.14	282.14	261500.0
2018-08-15 09:00:00	SPY	ETF	282.16	282.43	282.04	282.37	435969.0
2018-08-15 09:30:00	SPY	ETF	282.38	282.54	281.34	281.345	9312198.0
2018-08-15 10:00:00	SPY	ETF	281.345	281.36	280.48	280.5027	10762638.0
2018-08-15 10:30:00	SPY	ETF	280.5	281.02	280.16	280.29	7242803.0
2018-08-15 11:00:00	SPY	ETF	280.28	281.23	280.23	281.08	8287841.0
2018-08-15 11:30:00	SPY	ETF	281.07	281.47	280.59	280.61	4924250.0
2018-08-15 12:00:00	SPY	ETF	280.6	281.34	280.6	281.33	4512872.0
2018-08-15 12:30:00	SPY	ETF	281.33	281.69	281.3099	281.4616	4112658.0
2018-08-15 13:00:00	SPY	ETF	281.46	281.77	281.0	281.21	4238282.0
2018-08-15 13:30:00	SPY	ETF	281.2238	281.355	280.94	281.0199	2591179.0
2018-08-15 14:00:00	SPY	ETF	281.01	281.15	280.49	280.56	4477153.0
2018-08-15 14:30:00	SPY	ETF	280.56	281.27	280.45	281.26	4692329.0
2018-08-15 15:00:00	SPY	ETF	281.255	281.7	281.2	281.47	7532342.0
2018-08-15 15:30:00	SPY	ETF	281.46	282.1	281.45	281.76	16057641.0
2018-08-15 16:00:00	SPY	ETF	281.76	282.09	281.7316	282.04	9089207.0
2018-08-15 16:30:00	SPY	ETF	282.09	282.15	281.78	282.12	1095940.0
2018-08-15 17:00:00	SPY	ETF	282.09	282.11	282.04	282.04	304052.0
2018-08-15 17:30:00	SPY	ETF	282.05	282.06	282.01	282.03	42883.0
2018-08-15 18:00:00	SPY	ETF	282.05	282.17	281.93	282.03	81232.0
2018-08-15 18:30:00	SPY	ETF	282.03	282.03	281.98	282.02	6050.0
2018-08-15 19:00:00	SPY	ETF	282.03	282.05	281.99	281.99	5900.0
2018-08-15 19:30:00	SPY	ETF	281.99	282.02	281.86	281.93	38534.0
2018-08-15 04:00:00	QQQ	ETF	181.4	181.44	181.31	181.4	11250.0
2018-08-15 04:30:00	QQQ	ETF	181.42	181.42	181.35	181.35	2920.0
2018-08-15 05:00:00	QQQ	ETF	181.39	181.39	181.24	181.24	3791.0
2018-08-15 05:30:00	QQQ	ETF	181.24	181.24	181.14	181.14	10045.0
2018-08-15 06:00:00	QQQ	ETF	181.14	181.15	180.65	180.72	13243.0
2018-08-15 06:30:00	QQQ	ETF	180.64	180.64	180.22	180.31	70912.0
2018-08-15 07:00:00	QQQ	ETF	180.3	180.4	180.16	180.17	111768.0
2018-08-15 07:30:00	QQQ	ETF	180.16	180.16	179.78	180.04	255772.0
2018-08-15 08:00:00	QQQ	ETF	179.7801	181.38	179.78	180.17	207387.0
2018-08-15 08:30:00	QQQ	ETF	180.18	180.23	179.88	179.89	313994.0
2018-08-15 09:00:00	QQQ	ETF	179.88	180.13	179.84	180.08	221555.0
2018-08-15 09:30:00	QQQ	ETF	180.09	180.58	179.5	179.51	5847414.0
2018-08-15 10:00:00	QQQ	ETF	179.51	179.51	178.25	178.25	6199146.0
2018-08-15 10:30:00	QQQ	ETF	178.25	178.9	178.12	178.32	4552970.0
2018-08-15 11:00:00	QQQ	ETF	178.3101	178.96	178.26	178.78	4736328.0
2018-08-15 11:30:00	QQQ	ETF	178.77	179.1	178.27	178.299	3626174.0
2018-08-15 12:00:00	QQQ	ETF	178.28	178.91	178.28	178.86	2068934.0
2018-08-15 12:30:00	QQQ	ETF	178.86	179.22	178.85	179.0	1760199.0

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

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