PREVIEW / etf_30min / 2018-08-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-21.parquet
  size:    483 KB
  rows:    16,457

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-21 04:00:00	SPY	ETF	285.98	285.98	285.9	285.94	4244.0
2018-08-21 04:30:00	SPY	ETF	285.98	286.05	285.97	286.05	4041.0
2018-08-21 05:00:00	SPY	ETF	286.1	286.22	286.06	286.22	7261.0
2018-08-21 05:30:00	SPY	ETF	286.25	286.33	286.13	286.33	6537.0
2018-08-21 06:00:00	SPY	ETF	286.28	286.33	286.21	286.33	5330.0
2018-08-21 06:30:00	SPY	ETF	286.3	286.3	286.23	286.28	2150.0
2018-08-21 07:00:00	SPY	ETF	286.28	286.32	286.17	286.22	23976.0
2018-08-21 07:30:00	SPY	ETF	286.24	286.29	286.23	286.29	74087.0
2018-08-21 08:00:00	SPY	ETF	286.2899	286.2899	286.12	286.22	666065.0
2018-08-21 08:30:00	SPY	ETF	286.2	286.23	286.1	286.14	101907.0
2018-08-21 09:00:00	SPY	ETF	286.14	286.26	286.02	286.26	190611.0
2018-08-21 09:30:00	SPY	ETF	286.25	286.86	286.19	286.825	6298794.0
2018-08-21 10:00:00	SPY	ETF	286.83	286.88	286.56	286.67	5815252.0
2018-08-21 10:30:00	SPY	ETF	286.675	286.8	286.57	286.65	2859320.0
2018-08-21 11:00:00	SPY	ETF	286.65	286.74	286.29	286.495	2694915.0
2018-08-21 11:30:00	SPY	ETF	286.5	287.0	286.465	286.97	2883980.0
2018-08-21 12:00:00	SPY	ETF	286.97	287.165	286.96	287.13	3212032.0
2018-08-21 12:30:00	SPY	ETF	287.13	287.31	287.115	287.22	1894485.0
2018-08-21 13:00:00	SPY	ETF	287.225	287.285	286.98	287.13	3233280.0
2018-08-21 13:30:00	SPY	ETF	287.13	287.26	287.07	287.11	3226388.0
2018-08-21 14:00:00	SPY	ETF	287.11	287.14	286.935	287.0258	2442286.0
2018-08-21 14:30:00	SPY	ETF	287.02	287.02	286.48	286.685	5156170.0
2018-08-21 15:00:00	SPY	ETF	286.68	286.83	286.51	286.67	4507552.0
2018-08-21 15:30:00	SPY	ETF	286.665	286.74	286.105	286.25	12426333.0
2018-08-21 16:00:00	SPY	ETF	286.26	286.34	286.0	286.0	5946551.0
2018-08-21 16:30:00	SPY	ETF	286.02	286.06	285.13	285.36	1440541.0
2018-08-21 17:00:00	SPY	ETF	285.36	285.45	285.22	285.22	266091.0
2018-08-21 17:30:00	SPY	ETF	285.23	285.3	285.18	285.27	84635.0
2018-08-21 18:00:00	SPY	ETF	285.25	286.34	285.15	285.25	155208.0
2018-08-21 18:30:00	SPY	ETF	285.2	285.26	284.89	284.91	88213.0
2018-08-21 19:00:00	SPY	ETF	284.91	284.95	284.64	284.69	116620.0
2018-08-21 19:30:00	SPY	ETF	284.68	284.94	284.65	284.68	127856.0
2018-08-21 04:00:00	QQQ	ETF	180.01	180.02	180.0	180.02	2986.0
2018-08-21 04:30:00	QQQ	ETF	180.08	180.14	180.08	180.14	1506.0
2018-08-21 05:00:00	QQQ	ETF	180.18	180.26	180.17	180.26	7000.0
2018-08-21 05:30:00	QQQ	ETF	180.25	180.3	180.21	180.3	7123.0
2018-08-21 06:00:00	QQQ	ETF	180.35	180.39	180.28	180.36	8622.0
2018-08-21 06:30:00	QQQ	ETF	180.38	180.39	180.33	180.34	7043.0
2018-08-21 07:00:00	QQQ	ETF	180.29	180.31	180.18	180.21	8625.0
2018-08-21 07:30:00	QQQ	ETF	180.22	180.36	180.22	180.31	28893.0
2018-08-21 08:00:00	QQQ	ETF	180.3	180.3	179.92	180.24	41333.0
2018-08-21 08:30:00	QQQ	ETF	180.29	180.29	180.14	180.21	29436.0
2018-08-21 09:00:00	QQQ	ETF	180.23	180.27	180.14	180.24	30933.0
2018-08-21 09:30:00	QQQ	ETF	180.26	180.88	180.13	180.805	2413714.0
2018-08-21 10:00:00	QQQ	ETF	180.81	180.92	180.6	180.74	1687411.0
2018-08-21 10:30:00	QQQ	ETF	180.75	180.93	180.64	180.76	1019769.0
2018-08-21 11:00:00	QQQ	ETF	180.76	180.83	180.395	180.6	853409.0
2018-08-21 11:30:00	QQQ	ETF	180.6	181.1	180.56	181.07	1055873.0
2018-08-21 12:00:00	QQQ	ETF	181.07	181.27	181.0501	181.24	1225300.0
2018-08-21 12:30:00	QQQ	ETF	181.25	181.44	181.16	181.3365	675480.0

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

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