PREVIEW / etf_30min / 2018-01-25

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-25.parquet
  size:    490 KB
  rows:    16,915

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-01-25 04:00:00	SPY	ETF	283.39	283.45	283.39	283.45	1890.0
2018-01-25 04:30:00	SPY	ETF	283.52	283.72	283.52	283.72	2000.0
2018-01-25 05:00:00	SPY	ETF	283.68	283.81	283.66	283.66	1100.0
2018-01-25 05:30:00	SPY	ETF	283.78	283.93	283.78	283.93	2506.0
2018-01-25 06:00:00	SPY	ETF	283.92	284.01	283.92	283.95	3181.0
2018-01-25 06:30:00	SPY	ETF	283.99	284.01	283.93	283.95	4285.0
2018-01-25 07:00:00	SPY	ETF	283.95	284.29	283.95	284.15	148627.0
2018-01-25 07:30:00	SPY	ETF	284.18	284.26	284.1	284.12	43693.0
2018-01-25 08:00:00	SPY	ETF	283.18	284.26	283.18	284.18	153290.0
2018-01-25 08:30:00	SPY	ETF	284.19	284.65	284.13	284.52	580406.0
2018-01-25 09:00:00	SPY	ETF	284.52	284.55	283.91	284.16	562111.0
2018-01-25 09:30:00	SPY	ETF	284.16	284.27	282.71	282.959	7661463.0
2018-01-25 10:00:00	SPY	ETF	282.96	283.51	282.71	283.16	7475412.0
2018-01-25 10:30:00	SPY	ETF	283.17	283.63	282.92	283.32	3249428.0
2018-01-25 11:00:00	SPY	ETF	283.32	283.67	283.21	283.55	3641177.0
2018-01-25 11:30:00	SPY	ETF	283.56	284.03	283.48	283.731	3875988.0
2018-01-25 12:00:00	SPY	ETF	283.7352	284.07	283.68	283.86	2541080.0
2018-01-25 12:30:00	SPY	ETF	283.86	283.94	283.57	283.65	2405710.0
2018-01-25 13:00:00	SPY	ETF	283.65	283.7415	283.36	283.52	2458186.0
2018-01-25 13:30:00	SPY	ETF	283.515	283.92	283.43	283.78	1289555.0
2018-01-25 14:00:00	SPY	ETF	283.78	283.855	283.1	283.33	9158706.0
2018-01-25 14:30:00	SPY	ETF	283.34	283.4	282.64	282.78	5006505.0
2018-01-25 15:00:00	SPY	ETF	282.78	283.24	282.405	283.0915	9226050.0
2018-01-25 15:30:00	SPY	ETF	283.1	283.38	282.93	283.28	9523243.0
2018-01-25 16:00:00	SPY	ETF	283.28	283.45	283.24	283.44	7300215.0
2018-01-25 16:30:00	SPY	ETF	283.44	284.1651	283.3	283.54	3617388.0
2018-01-25 17:00:00	SPY	ETF	283.51	283.59	283.284	283.56	3085617.0
2018-01-25 17:30:00	SPY	ETF	283.56	283.6	283.55	283.57	48727.0
2018-01-25 18:00:00	SPY	ETF	283.57	283.63	283.45	283.61	109200.0
2018-01-25 18:30:00	SPY	ETF	283.61	283.67	283.58	283.6	90397.0
2018-01-25 19:00:00	SPY	ETF	283.66	283.8	283.66	283.66	5625.0
2018-01-25 19:30:00	SPY	ETF	283.69	283.75	283.61	283.65	18141.0
2018-01-25 04:00:00	QQQ	ETF	168.84	168.84	168.8	168.81	12400.0
2018-01-25 04:30:00	QQQ	ETF	168.82	169.15	168.82	169.15	2800.0
2018-01-25 05:00:00	QQQ	ETF	169.13	169.17	168.97	168.97	3350.0
2018-01-25 05:30:00	QQQ	ETF	169.12	169.29	169.11	169.29	2600.0
2018-01-25 06:00:00	QQQ	ETF	169.24	169.29	169.23	169.29	2350.0
2018-01-25 06:30:00	QQQ	ETF	169.25	169.34	169.24	169.24	13330.0
2018-01-25 07:00:00	QQQ	ETF	169.25	169.5	169.24	169.46	95233.0
2018-01-25 07:30:00	QQQ	ETF	169.45	169.51	169.41	169.41	76760.0
2018-01-25 08:00:00	QQQ	ETF	168.41	169.63	168.41	169.53	149265.0
2018-01-25 08:30:00	QQQ	ETF	169.53	169.86	168.41	169.73	252949.0
2018-01-25 09:00:00	QQQ	ETF	169.72	169.78	169.42	169.56	199413.0
2018-01-25 09:30:00	QQQ	ETF	169.55	169.63	168.16	168.33	5104414.0
2018-01-25 10:00:00	QQQ	ETF	168.34	168.76	168.19	168.4164	2945968.0
2018-01-25 10:30:00	QQQ	ETF	168.43	168.89	168.32	168.75	2174882.0
2018-01-25 11:00:00	QQQ	ETF	168.76	169.025	168.67	169.025	1313873.0
2018-01-25 11:30:00	QQQ	ETF	169.03	169.31	168.905	169.2547	1137030.0
2018-01-25 12:00:00	QQQ	ETF	169.26	169.41	169.0451	169.15	1057367.0
2018-01-25 12:30:00	QQQ	ETF	169.14	169.18	168.8099	168.82	982682.0

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

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