PREVIEW / etf_30min / 2015-09-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-15.parquet
  size:    373 KB
  rows:    12,582

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-09-15 04:00:00	SPY	ETF	195.8	195.83	195.42	195.58	46689.0
2015-09-15 04:30:00	SPY	ETF	195.6	195.71	195.54	195.71	11209.0
2015-09-15 05:00:00	SPY	ETF	195.63	195.71	195.3	195.57	37753.0
2015-09-15 05:30:00	SPY	ETF	195.61	195.66	195.6	195.66	12409.0
2015-09-15 06:00:00	SPY	ETF	195.66	196.05	195.51	195.93	31452.0
2015-09-15 06:30:00	SPY	ETF	196.02	196.39	196.02	196.21	19614.0
2015-09-15 07:00:00	SPY	ETF	196.29	196.35	196.1	196.25	41823.0
2015-09-15 07:30:00	SPY	ETF	196.27	196.41	196.07	196.15	50565.0
2015-09-15 08:00:00	SPY	ETF	196.11	196.41	196.01	196.32	162075.0
2015-09-15 08:30:00	SPY	ETF	196.31	196.62	196.0	196.53	331953.0
2015-09-15 09:00:00	SPY	ETF	196.53	196.9	196.53	196.61	780995.0
2015-09-15 09:30:00	SPY	ETF	196.61	196.79	196.09	196.48	9746936.0
2015-09-15 10:00:00	SPY	ETF	196.48	197.11	196.34	196.82	5920836.0
2015-09-15 10:30:00	SPY	ETF	196.81	197.82	196.81	197.64	11127565.0
2015-09-15 11:00:00	SPY	ETF	197.635	197.73	197.4	197.55	6307683.0
2015-09-15 11:30:00	SPY	ETF	197.54	197.77	197.32	197.57	4346286.0
2015-09-15 12:00:00	SPY	ETF	197.57	197.91	197.47	197.8	3911761.0
2015-09-15 12:30:00	SPY	ETF	197.8	197.93	197.65	197.7	3490917.0
2015-09-15 13:00:00	SPY	ETF	197.7	198.31	197.62	198.23	5836766.0
2015-09-15 13:30:00	SPY	ETF	198.22	198.56	198.175	198.26	7961902.0
2015-09-15 14:00:00	SPY	ETF	198.27	198.67	198.2	198.46	6461437.0
2015-09-15 14:30:00	SPY	ETF	198.46	198.83	198.38	198.79	7767143.0
2015-09-15 15:00:00	SPY	ETF	198.79	198.99	198.73	198.86	8574277.0
2015-09-15 15:30:00	SPY	ETF	198.85	198.95	198.44	198.49	18900533.0
2015-09-15 16:00:00	SPY	ETF	198.49	198.8	197.9598	198.65	6188601.0
2015-09-15 16:30:00	SPY	ETF	198.65	198.84	198.64	198.79	1582683.0
2015-09-15 17:00:00	SPY	ETF	198.78	198.81	195.9701	198.81	532262.0
2015-09-15 17:30:00	SPY	ETF	198.79	198.84	198.66	198.72	56361.0
2015-09-15 18:00:00	SPY	ETF	198.68	198.75	198.61	198.69	57945.0
2015-09-15 18:30:00	SPY	ETF	198.71	198.71	198.69	198.7	2733.0
2015-09-15 19:00:00	SPY	ETF	198.73	198.75	198.7	198.72	24389.0
2015-09-15 19:30:00	SPY	ETF	198.74	198.78	198.65	198.66	74930.0
2015-09-15 04:00:00	QQQ	ETF	105.07	105.07	104.97	104.97	800.0
2015-09-15 05:00:00	QQQ	ETF	104.87	104.91	104.81	104.91	1900.0
2015-09-15 05:30:00	QQQ	ETF	105.02	105.02	105.0	105.0	300.0
2015-09-15 06:00:00	QQQ	ETF	105.08	105.16	104.94	105.16	2730.0
2015-09-15 06:30:00	QQQ	ETF	105.15	105.4	105.15	105.33	1343.0
2015-09-15 07:00:00	QQQ	ETF	105.37	105.37	105.3	105.35	4200.0
2015-09-15 07:30:00	QQQ	ETF	105.37	105.38	105.23	105.29	15200.0
2015-09-15 08:00:00	QQQ	ETF	105.26	105.35	105.18	105.35	9666.0
2015-09-15 08:30:00	QQQ	ETF	105.28	105.52	105.18	105.5	52564.0
2015-09-15 09:00:00	QQQ	ETF	105.49	105.66	105.45	105.5	113259.0
2015-09-15 09:30:00	QQQ	ETF	105.5	105.59	105.11	105.4	3201032.0
2015-09-15 10:00:00	QQQ	ETF	105.4	105.92	105.4	105.81	1925630.0
2015-09-15 10:30:00	QQQ	ETF	105.81	106.33	105.81	106.19	3922831.0
2015-09-15 11:00:00	QQQ	ETF	106.2	106.269	106.04	106.11	2085276.0
2015-09-15 11:30:00	QQQ	ETF	106.12	106.19	105.98	106.091	1159161.0
2015-09-15 12:00:00	QQQ	ETF	106.09	106.27	106.04	106.23	857144.0
2015-09-15 12:30:00	QQQ	ETF	106.24	106.28	106.12	106.137	767684.0
2015-09-15 13:00:00	QQQ	ETF	106.13	106.466	106.1	106.41	1394806.0

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

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