PREVIEW / etf_30min / 2018-10-08

all etf 30-min files

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

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-08 04:00:00	SPY	ETF	287.5	287.72	287.4	287.43	21266.0
2018-10-08 04:30:00	SPY	ETF	287.4	287.4	287.2	287.2	7010.0
2018-10-08 05:00:00	SPY	ETF	287.23	287.45	287.23	287.45	3612.0
2018-10-08 05:30:00	SPY	ETF	287.45	287.74	287.45	287.63	14283.0
2018-10-08 06:00:00	SPY	ETF	287.66	287.74	287.41	287.41	22392.0
2018-10-08 06:30:00	SPY	ETF	287.44	287.56	287.34	287.52	46176.0
2018-10-08 07:00:00	SPY	ETF	287.49	287.65	287.41	287.65	61994.0
2018-10-08 07:30:00	SPY	ETF	287.66	287.83	287.63	287.79	144877.0
2018-10-08 08:00:00	SPY	ETF	287.716	288.31	287.44	287.62	253577.0
2018-10-08 08:30:00	SPY	ETF	287.63	287.64	287.43	287.5	302104.0
2018-10-08 09:00:00	SPY	ETF	287.5	287.82	287.03	287.04	599172.0
2018-10-08 09:30:00	SPY	ETF	287.05	288.0	286.71	287.7275	7387017.0
2018-10-08 10:00:00	SPY	ETF	287.73	288.19	287.66	288.035	3692724.0
2018-10-08 10:30:00	SPY	ETF	288.04	288.085	287.39	287.57	2941221.0
2018-10-08 11:00:00	SPY	ETF	287.57	287.5985	286.93	286.94	3319744.0
2018-10-08 11:30:00	SPY	ETF	286.94	286.98	285.5	286.135	10562914.0
2018-10-08 12:00:00	SPY	ETF	286.1367	286.5388	285.79	286.49	5966284.0
2018-10-08 12:30:00	SPY	ETF	286.49	286.5299	285.57	285.6	3497045.0
2018-10-08 13:00:00	SPY	ETF	285.59	286.42	285.55	285.79	4358826.0
2018-10-08 13:30:00	SPY	ETF	285.8	286.69	285.78	286.4	4540999.0
2018-10-08 14:00:00	SPY	ETF	286.3827	287.46	286.34	287.23	6674429.0
2018-10-08 14:30:00	SPY	ETF	287.24	287.94	287.24	287.59	5106552.0
2018-10-08 15:00:00	SPY	ETF	287.59	288.135	287.515	287.759	5620513.0
2018-10-08 15:30:00	SPY	ETF	287.76	288.22	287.745	287.8	12202749.0
2018-10-08 16:00:00	SPY	ETF	287.78	288.23	286.0	288.21	8437603.0
2018-10-08 16:30:00	SPY	ETF	288.2	288.21	288.01	288.09	271073.0
2018-10-08 17:00:00	SPY	ETF	288.09	288.09	288.01	288.02	125369.0
2018-10-08 17:30:00	SPY	ETF	288.03	288.09	288.03	288.06	22689.0
2018-10-08 18:00:00	SPY	ETF	288.06	288.15	288.0	288.09	53202.0
2018-10-08 18:30:00	SPY	ETF	288.11	288.11	288.03	288.08	12950.0
2018-10-08 19:00:00	SPY	ETF	288.12	288.12	287.95	288.01	7062.0
2018-10-08 19:30:00	SPY	ETF	288.02	288.02	287.89	287.94	18013.0
2018-10-08 04:00:00	QQQ	ETF	179.85	179.86	179.59	179.59	4310.0
2018-10-08 04:30:00	QQQ	ETF	179.62	179.63	179.4	179.44	3464.0
2018-10-08 05:00:00	QQQ	ETF	179.46	179.72	179.46	179.71	13393.0
2018-10-08 05:30:00	QQQ	ETF	179.73	180.01	179.73	179.93	26416.0
2018-10-08 06:00:00	QQQ	ETF	179.97	180.06	179.8	179.9	21540.0
2018-10-08 06:30:00	QQQ	ETF	179.88	179.95	179.76	179.86	31248.0
2018-10-08 07:00:00	QQQ	ETF	179.92	180.07	179.83	180.06	45277.0
2018-10-08 07:30:00	QQQ	ETF	180.07	180.28	180.07	180.23	157307.0
2018-10-08 08:00:00	QQQ	ETF	179.85	180.51	179.85	180.07	126458.0
2018-10-08 08:30:00	QQQ	ETF	180.05	180.07	179.82	179.9	233460.0
2018-10-08 09:00:00	QQQ	ETF	179.87	179.9	179.35	179.35	287371.0
2018-10-08 09:30:00	QQQ	ETF	179.36	180.27	178.72	180.08	5688476.0
2018-10-08 10:00:00	QQQ	ETF	180.08	180.6427	179.75	180.42	2752532.0
2018-10-08 10:30:00	QQQ	ETF	180.42	180.44	179.45	179.75	2505333.0
2018-10-08 11:00:00	QQQ	ETF	179.74	179.76	178.78	178.81	3969600.0
2018-10-08 11:30:00	QQQ	ETF	178.79	178.84	177.12	178.1	8594867.0
2018-10-08 12:00:00	QQQ	ETF	178.1	178.2455	177.28	178.19	4691808.0
2018-10-08 12:30:00	QQQ	ETF	178.18	178.23	176.95	177.0	4610921.0

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

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