PREVIEW / etf_30min / 2018-08-10

all etf 30-min files

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

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-10 04:00:00	SPY	ETF	284.02	284.09	283.68	283.81	51324.0
2018-08-10 04:30:00	SPY	ETF	283.95	283.99	283.68	283.78	21732.0
2018-08-10 05:00:00	SPY	ETF	283.75	284.08	283.75	283.85	9434.0
2018-08-10 05:30:00	SPY	ETF	283.88	283.93	283.4	283.49	29504.0
2018-08-10 06:00:00	SPY	ETF	283.56	283.89	283.48	283.89	22445.0
2018-08-10 06:30:00	SPY	ETF	283.88	283.98	283.8	283.95	17247.0
2018-08-10 07:00:00	SPY	ETF	283.95	284.0	283.82	283.94	102110.0
2018-08-10 07:30:00	SPY	ETF	283.95	283.98	283.75	283.77	106917.0
2018-08-10 08:00:00	SPY	ETF	283.77	284.09	283.57	283.79	427407.0
2018-08-10 08:30:00	SPY	ETF	283.77	284.1	283.5	283.69	637560.0
2018-08-10 09:00:00	SPY	ETF	283.69	283.77	283.27	283.43	866242.0
2018-08-10 09:30:00	SPY	ETF	283.45	283.91	283.17	283.25	9506841.0
2018-08-10 10:00:00	SPY	ETF	283.24	283.72	282.96	283.36	5764145.0
2018-08-10 10:30:00	SPY	ETF	283.36	283.7	283.13	283.67	4544354.0
2018-08-10 11:00:00	SPY	ETF	283.67	283.955	283.4	283.75	3898015.0
2018-08-10 11:30:00	SPY	ETF	283.75	284.055	283.66	283.705	3749475.0
2018-08-10 12:00:00	SPY	ETF	283.7	283.71	283.48	283.69	2515097.0
2018-08-10 12:30:00	SPY	ETF	283.69	283.76	283.41	283.56	2071095.0
2018-08-10 13:00:00	SPY	ETF	283.56	283.59	283.18	283.395	3606936.0
2018-08-10 13:30:00	SPY	ETF	283.395	283.44	282.72	282.77	3583027.0
2018-08-10 14:00:00	SPY	ETF	282.77	283.04	282.41	282.41	4480704.0
2018-08-10 14:30:00	SPY	ETF	282.42	282.84	282.39	282.639	3501290.0
2018-08-10 15:00:00	SPY	ETF	282.635	283.6	282.36	283.33	7086683.0
2018-08-10 15:30:00	SPY	ETF	283.33	283.4	282.96	283.12	8819668.0
2018-08-10 16:00:00	SPY	ETF	283.12	283.57	282.6684	283.47	10070520.0
2018-08-10 16:30:00	SPY	ETF	283.46	283.67	283.42	283.66	348573.0
2018-08-10 17:00:00	SPY	ETF	283.67	283.67	283.35	283.38	80123.0
2018-08-10 17:30:00	SPY	ETF	283.4	283.61	283.16	283.61	65364.0
2018-08-10 18:00:00	SPY	ETF	283.61	283.74	283.42	283.67	140590.0
2018-08-10 18:30:00	SPY	ETF	283.66	283.7	283.66	283.7	15675.0
2018-08-10 19:00:00	SPY	ETF	283.71	283.72	283.67	283.68	14199.0
2018-08-10 19:30:00	SPY	ETF	283.69	283.73	283.69	283.7	13826.0
2018-08-10 04:00:00	QQQ	ETF	181.16	181.16	181.0	181.02	5636.0
2018-08-10 04:30:00	QQQ	ETF	181.03	181.12	180.99	181.02	25200.0
2018-08-10 05:00:00	QQQ	ETF	181.02	181.21	181.02	181.07	4580.0
2018-08-10 05:30:00	QQQ	ETF	181.09	181.09	180.72	180.75	15100.0
2018-08-10 06:00:00	QQQ	ETF	180.75	180.96	180.69	180.96	20530.0
2018-08-10 06:30:00	QQQ	ETF	180.92	181.03	180.91	181.01	9830.0
2018-08-10 07:00:00	QQQ	ETF	181.05	181.06	180.92	181.04	33491.0
2018-08-10 07:30:00	QQQ	ETF	181.03	181.07	180.84	180.87	69235.0
2018-08-10 08:00:00	QQQ	ETF	180.85	181.91	180.7	180.9	177354.0
2018-08-10 08:30:00	QQQ	ETF	180.84	181.08	180.78	180.86	214981.0
2018-08-10 09:00:00	QQQ	ETF	180.88	180.92	180.55	180.63	230786.0
2018-08-10 09:30:00	QQQ	ETF	180.68	181.22	180.56	180.58	4035690.0
2018-08-10 10:00:00	QQQ	ETF	180.57	181.135	180.39	180.86	2550648.0
2018-08-10 10:30:00	QQQ	ETF	180.8699	181.18	180.47	180.8	2421502.0
2018-08-10 11:00:00	QQQ	ETF	180.8	181.1	180.69	180.9355	1477764.0
2018-08-10 11:30:00	QQQ	ETF	180.94	181.13	180.86	180.945	1204231.0
2018-08-10 12:00:00	QQQ	ETF	180.94	181.01	180.74	181.0	852004.0
2018-08-10 12:30:00	QQQ	ETF	181.0001	181.085	180.81	180.95	594389.0

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

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