PREVIEW / etf_30min / 2015-01-29

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-29.parquet
  size:    386 KB
  rows:    12,830

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
2015-01-29 04:00:00	SPY	ETF	199.88	200.0	199.88	200.0	863.0
2015-01-29 04:30:00	SPY	ETF	199.86	200.12	199.86	199.96	11300.0
2015-01-29 05:00:00	SPY	ETF	199.96	200.26	199.94	200.26	42994.0
2015-01-29 05:30:00	SPY	ETF	200.35	200.51	200.15	200.26	17500.0
2015-01-29 06:00:00	SPY	ETF	200.22	200.26	200.04	200.09	2829.0
2015-01-29 06:30:00	SPY	ETF	200.12	200.75	200.12	200.62	77255.0
2015-01-29 07:00:00	SPY	ETF	200.64	200.69	200.39	200.47	191018.0
2015-01-29 07:30:00	SPY	ETF	200.47	200.67	200.09	200.15	281351.0
2015-01-29 08:00:00	SPY	ETF	200.17	200.66	199.67	199.93	442342.0
2015-01-29 08:30:00	SPY	ETF	199.9	200.39	199.85	200.22	1090020.0
2015-01-29 09:00:00	SPY	ETF	200.24	200.37	199.9	200.36	1022024.0
2015-01-29 09:30:00	SPY	ETF	200.38	200.58	199.01	199.87	23578983.0
2015-01-29 10:00:00	SPY	ETF	199.86	200.2	199.26	199.8749	13651654.0
2015-01-29 10:30:00	SPY	ETF	199.87	199.91	198.68	199.235	14841565.0
2015-01-29 11:00:00	SPY	ETF	199.23	199.6	198.83	199.3	11943857.0
2015-01-29 11:30:00	SPY	ETF	199.31	200.21	199.31	199.85	10190730.0
2015-01-29 12:00:00	SPY	ETF	199.85	200.38	199.82	200.04	6403809.0
2015-01-29 12:30:00	SPY	ETF	200.05	200.14	199.52	199.94	5203301.0
2015-01-29 13:00:00	SPY	ETF	199.95	200.56	199.67	200.5	5205042.0
2015-01-29 13:30:00	SPY	ETF	200.5	201.22	200.35	200.84	8919177.0
2015-01-29 14:00:00	SPY	ETF	200.85	201.28	200.63	201.265	6480070.0
2015-01-29 14:30:00	SPY	ETF	201.265	201.44	200.905	201.14	5702695.0
2015-01-29 15:00:00	SPY	ETF	201.13	202.0	201.03	201.78	9992150.0
2015-01-29 15:30:00	SPY	ETF	201.78	202.3	201.76	201.98	16026870.0
2015-01-29 16:00:00	SPY	ETF	202.0	202.36	199.7667	202.22	5838437.0
2015-01-29 16:30:00	SPY	ETF	202.22	202.42	202.01	202.33	6553175.0
2015-01-29 17:00:00	SPY	ETF	202.35	202.43	202.31	202.39	16127245.0
2015-01-29 17:30:00	SPY	ETF	202.42	202.45	202.38	202.39	35173.0
2015-01-29 18:00:00	SPY	ETF	202.38	202.45	202.255	202.35	78010.0
2015-01-29 18:30:00	SPY	ETF	202.35	202.35	202.19	202.24	30417.0
2015-01-29 19:00:00	SPY	ETF	202.2	202.22	202.0	202.06	101665.0
2015-01-29 19:30:00	SPY	ETF	202.06	202.08	201.95	202.0	58445.0
2015-01-29 06:30:00	QQQ	ETF	101.04	101.11	100.99	101.02	40750.0
2015-01-29 07:00:00	QQQ	ETF	101.09	101.14	100.85	100.92	129600.0
2015-01-29 07:30:00	QQQ	ETF	100.94	100.94	100.78	100.8	43965.0
2015-01-29 08:00:00	QQQ	ETF	100.8	100.8	100.55	100.64	247501.0
2015-01-29 08:30:00	QQQ	ETF	100.67	100.92	100.67	100.81	173055.0
2015-01-29 09:00:00	QQQ	ETF	100.83	100.89	100.66	100.84	253292.0
2015-01-29 09:30:00	QQQ	ETF	100.84	100.99	99.96	100.48	7276410.0
2015-01-29 10:00:00	QQQ	ETF	100.485	100.73	100.28	100.68	4000915.0
2015-01-29 10:30:00	QQQ	ETF	100.69	100.69	100.08	100.375	3102288.0
2015-01-29 11:00:00	QQQ	ETF	100.37	100.6	100.14	100.38	2103255.0
2015-01-29 11:30:00	QQQ	ETF	100.4	100.77	100.39	100.56	2593881.0
2015-01-29 12:00:00	QQQ	ETF	100.565	100.84	100.485	100.61	1566291.0
2015-01-29 12:30:00	QQQ	ETF	100.61	100.65	100.36	100.5901	1405003.0
2015-01-29 13:00:00	QQQ	ETF	100.6	100.9	100.44	100.864	1351563.0
2015-01-29 13:30:00	QQQ	ETF	100.87	101.29	100.81	101.129	2547296.0
2015-01-29 14:00:00	QQQ	ETF	101.13	101.4	101.04	101.39	1511260.0
2015-01-29 14:30:00	QQQ	ETF	101.39	101.53	101.24	101.43	1416213.0
2015-01-29 15:00:00	QQQ	ETF	101.43	101.92	101.36	101.817	2362358.0

> showing 50 of 12,830 rows — these rows as CSV

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