PREVIEW / etf_30min / 2018-08-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-16.parquet
  size:    481 KB
  rows:    16,314

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-16 04:00:00	SPY	ETF	282.5	282.81	282.5	282.81	5310.0
2018-08-16 04:30:00	SPY	ETF	282.84	283.07	282.79	283.07	12347.0
2018-08-16 05:00:00	SPY	ETF	283.05	283.05	282.9	282.99	22018.0
2018-08-16 05:30:00	SPY	ETF	283.01	283.11	282.99	283.03	17302.0
2018-08-16 06:00:00	SPY	ETF	283.03	283.37	283.03	283.22	26508.0
2018-08-16 06:30:00	SPY	ETF	283.26	283.53	283.18	283.52	58896.0
2018-08-16 07:00:00	SPY	ETF	283.47	283.61	283.33	283.4	216350.0
2018-08-16 07:30:00	SPY	ETF	283.4	283.4	283.2	283.3	132238.0
2018-08-16 08:00:00	SPY	ETF	283.5099	283.61	282.98	283.44	130506.0
2018-08-16 08:30:00	SPY	ETF	283.41	283.45	281.78	283.12	359587.0
2018-08-16 09:00:00	SPY	ETF	283.09	283.44	283.05	283.34	337855.0
2018-08-16 09:30:00	SPY	ETF	283.4	283.77	283.36	283.54	6327138.0
2018-08-16 10:00:00	SPY	ETF	283.55	283.87	283.5403	283.86	3670262.0
2018-08-16 10:30:00	SPY	ETF	283.87	284.13	283.81	283.95	3506874.0
2018-08-16 11:00:00	SPY	ETF	283.95	284.53	283.94	284.52	3709304.0
2018-08-16 11:30:00	SPY	ETF	284.52	284.62	284.36	284.6	2409316.0
2018-08-16 12:00:00	SPY	ETF	284.6	285.04	284.58	284.8053	3753559.0
2018-08-16 12:30:00	SPY	ETF	284.805	284.835	284.4	284.53	4752296.0
2018-08-16 13:00:00	SPY	ETF	284.53	284.76	284.48	284.6529	4063812.0
2018-08-16 13:30:00	SPY	ETF	284.66	284.8	284.4	284.4685	2048995.0
2018-08-16 14:00:00	SPY	ETF	284.47	284.61	284.26	284.2736	3315514.0
2018-08-16 14:30:00	SPY	ETF	284.275	284.47	283.95	284.35	6525760.0
2018-08-16 15:00:00	SPY	ETF	284.36	284.49	284.18	284.44	2937748.0
2018-08-16 15:30:00	SPY	ETF	284.44	284.45	283.72	284.1	12795169.0
2018-08-16 16:00:00	SPY	ETF	284.07	284.36	281.8178	284.27	6906360.0
2018-08-16 16:30:00	SPY	ETF	284.31	284.31	284.06	284.2	388080.0
2018-08-16 17:00:00	SPY	ETF	284.21	284.25	284.06	284.16	101262.0
2018-08-16 17:30:00	SPY	ETF	284.16	284.25	284.15	284.2	29093.0
2018-08-16 18:00:00	SPY	ETF	284.15	284.15	283.91	283.95	127994.0
2018-08-16 18:30:00	SPY	ETF	283.97	284.15	283.97	284.13	32399.0
2018-08-16 19:00:00	SPY	ETF	284.15	284.15	283.97	283.97	32757.0
2018-08-16 19:30:00	SPY	ETF	283.99	284.12	283.96	284.08	13700.0
2018-08-16 04:00:00	QQQ	ETF	180.21	180.45	180.11	180.45	9716.0
2018-08-16 04:30:00	QQQ	ETF	180.45	180.57	180.37	180.57	3250.0
2018-08-16 05:00:00	QQQ	ETF	180.45	180.58	180.4	180.5	8910.0
2018-08-16 05:30:00	QQQ	ETF	180.55	180.62	180.5	180.5	5381.0
2018-08-16 06:00:00	QQQ	ETF	180.6	180.83	180.6	180.7	33203.0
2018-08-16 06:30:00	QQQ	ETF	180.65	180.9	180.61	180.88	16650.0
2018-08-16 07:00:00	QQQ	ETF	180.85	180.89	180.66	180.7	77487.0
2018-08-16 07:30:00	QQQ	ETF	180.72	180.73	180.57	180.65	151992.0
2018-08-16 08:00:00	QQQ	ETF	180.57	180.82	180.41	180.62	141109.0
2018-08-16 08:30:00	QQQ	ETF	180.56	180.59	179.23	180.36	108796.0
2018-08-16 09:00:00	QQQ	ETF	180.38	180.64	180.3	180.6	102976.0
2018-08-16 09:30:00	QQQ	ETF	180.57	180.68	180.07	180.14	4179838.0
2018-08-16 10:00:00	QQQ	ETF	180.14	180.5599	180.14	180.5599	1393523.0
2018-08-16 10:30:00	QQQ	ETF	180.55	180.7	180.21	180.31	1274994.0
2018-08-16 11:00:00	QQQ	ETF	180.3	180.84	180.3	180.8	1298769.0
2018-08-16 11:30:00	QQQ	ETF	180.81	180.87	180.66	180.78	890498.0
2018-08-16 12:00:00	QQQ	ETF	180.77	180.99	180.75	180.79	1301849.0
2018-08-16 12:30:00	QQQ	ETF	180.8	180.82	180.52	180.63	900318.0

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

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