PREVIEW / etf_30min / 2015-01-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-15.parquet
  size:    391 KB
  rows:    13,133

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-15 04:00:00	SPY	ETF	202.4	202.44	202.3	202.33	15806.0
2015-01-15 04:30:00	SPY	ETF	201.97	202.08	199.4	201.0	1092425.0
2015-01-15 05:00:00	SPY	ETF	200.03	201.4	199.55	200.94	299195.0
2015-01-15 05:30:00	SPY	ETF	201.09	201.09	199.84	200.11	155247.0
2015-01-15 06:00:00	SPY	ETF	200.22	200.22	199.3	199.44	357790.0
2015-01-15 06:30:00	SPY	ETF	199.4	200.22	199.34	199.79	247841.0
2015-01-15 07:00:00	SPY	ETF	199.97	201.15	199.7	201.04	442967.0
2015-01-15 07:30:00	SPY	ETF	201.06	201.74	200.4	200.87	1044866.0
2015-01-15 08:00:00	SPY	ETF	199.71	201.55	199.71	200.84	908398.0
2015-01-15 08:30:00	SPY	ETF	200.85	202.21	200.8	201.74	2164822.0
2015-01-15 09:00:00	SPY	ETF	201.74	201.81	201.24	201.63	1587229.0
2015-01-15 09:30:00	SPY	ETF	201.63	202.01	199.62	199.92	24290415.0
2015-01-15 10:00:00	SPY	ETF	199.93	201.0	199.54	200.91	18068144.0
2015-01-15 10:30:00	SPY	ETF	200.91	201.48	200.25	200.32	11259417.0
2015-01-15 11:00:00	SPY	ETF	200.32	200.54	199.66	199.73	11968373.0
2015-01-15 11:30:00	SPY	ETF	199.74	200.42	199.5	199.91	10090344.0
2015-01-15 12:00:00	SPY	ETF	199.91	200.2	199.6	199.79	5964406.0
2015-01-15 12:30:00	SPY	ETF	199.79	199.8	198.97	199.3501	11673687.0
2015-01-15 13:00:00	SPY	ETF	199.355	200.03	199.21	199.33	10778095.0
2015-01-15 13:30:00	SPY	ETF	199.341	199.84	199.06	199.45	5744116.0
2015-01-15 14:00:00	SPY	ETF	199.45	199.87	199.26	199.54	6594213.0
2015-01-15 14:30:00	SPY	ETF	199.545	200.24	199.39	200.06	9227468.0
2015-01-15 15:00:00	SPY	ETF	200.0638	200.19	199.31	199.78	9082219.0
2015-01-15 15:30:00	SPY	ETF	199.77	199.99	198.88	199.02	18232329.0
2015-01-15 16:00:00	SPY	ETF	199.01	199.72	198.97	199.24	5752201.0
2015-01-15 16:30:00	SPY	ETF	199.25	199.79	198.79	198.81	3705974.0
2015-01-15 17:00:00	SPY	ETF	198.8	200.3519	198.29	198.48	591084.0
2015-01-15 17:30:00	SPY	ETF	198.49	198.55	198.41	198.51	178532.0
2015-01-15 18:00:00	SPY	ETF	198.51	198.74	198.35	198.64	229105.0
2015-01-15 18:30:00	SPY	ETF	198.6	198.6	198.35	198.42	200628.0
2015-01-15 19:00:00	SPY	ETF	198.39	198.47	197.76	197.84	439779.0
2015-01-15 19:30:00	SPY	ETF	197.88	198.17	197.88	198.13	293870.0
2015-01-15 04:00:00	QQQ	ETF	101.68	101.84	101.68	101.84	300.0
2015-01-15 04:30:00	QQQ	ETF	101.61	101.61	100.0	100.8	49450.0
2015-01-15 05:00:00	QQQ	ETF	100.42	101.0	100.42	101.0	3300.0
2015-01-15 05:30:00	QQQ	ETF	101.14	101.14	100.54	100.54	250.0
2015-01-15 06:00:00	QQQ	ETF	100.77	100.77	100.3	100.3	24000.0
2015-01-15 06:30:00	QQQ	ETF	100.34	100.71	100.34	100.56	10100.0
2015-01-15 07:00:00	QQQ	ETF	100.59	101.06	100.5	101.04	108150.0
2015-01-15 07:30:00	QQQ	ETF	101.08	101.29	100.65	100.92	256670.0
2015-01-15 08:00:00	QQQ	ETF	100.88	102.13	100.51	100.94	82218.0
2015-01-15 08:30:00	QQQ	ETF	101.2	101.52	100.96	101.2	379730.0
2015-01-15 09:00:00	QQQ	ETF	101.23	101.46	101.04	101.44	330854.0
2015-01-15 09:30:00	QQQ	ETF	101.43	101.59	100.11	100.27	7591185.0
2015-01-15 10:00:00	QQQ	ETF	100.24	100.8801	100.01	100.827	4868981.0
2015-01-15 10:30:00	QQQ	ETF	100.82	101.1	100.525	100.57	3050131.0
2015-01-15 11:00:00	QQQ	ETF	100.57	100.69	100.15	100.19	2283584.0
2015-01-15 11:30:00	QQQ	ETF	100.19	100.51	100.05	100.255	3481596.0
2015-01-15 12:00:00	QQQ	ETF	100.25	100.45	100.12	100.21	1819015.0
2015-01-15 12:30:00	QQQ	ETF	100.201	100.201	99.65	99.87	3501207.0

> showing 50 of 13,133 rows — these rows as CSV

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