PREVIEW / etf_30min / 2010-09-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-16.parquet
  size:    248 KB
  rows:    8,410

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
2010-09-16 04:00:00	SPY	ETF	112.86	112.91	112.86	112.91	1500.0
2010-09-16 04:30:00	SPY	ETF	112.81	112.83	112.74	112.83	1300.0
2010-09-16 05:00:00	SPY	ETF	112.86	112.86	112.86	112.86	100.0
2010-09-16 05:30:00	SPY	ETF	112.86	112.86	112.81	112.86	1200.0
2010-09-16 06:00:00	SPY	ETF	112.99	113.0	112.89	112.89	1300.0
2010-09-16 06:30:00	SPY	ETF	112.98	112.98	112.85	112.85	134700.0
2010-09-16 07:00:00	SPY	ETF	112.83	112.89	112.78	112.81	420155.0
2010-09-16 07:30:00	SPY	ETF	112.8	112.81	112.74	112.81	357722.0
2010-09-16 08:00:00	SPY	ETF	112.8	113.16	112.57	112.67	1570287.0
2010-09-16 08:30:00	SPY	ETF	112.78	112.93	112.49	112.62	2583197.0
2010-09-16 09:00:00	SPY	ETF	112.63	112.78	112.53	112.73	1266481.0
2010-09-16 09:30:00	SPY	ETF	112.73	112.89	112.44	112.675	19326038.0
2010-09-16 10:00:00	SPY	ETF	112.67	112.91	112.35	112.71	27504541.0
2010-09-16 10:30:00	SPY	ETF	112.71	112.83	112.46	112.7299	12520974.0
2010-09-16 11:00:00	SPY	ETF	112.73	112.83	112.54	112.64	8584046.0
2010-09-16 11:30:00	SPY	ETF	112.64	112.65	112.51	112.58	15083161.0
2010-09-16 12:00:00	SPY	ETF	112.59	112.63	112.43	112.55	7144825.0
2010-09-16 12:30:00	SPY	ETF	112.54	112.82	112.54	112.785	7938753.0
2010-09-16 13:00:00	SPY	ETF	112.785	112.8	112.52	112.66	7829597.0
2010-09-16 13:30:00	SPY	ETF	112.67	112.7	112.53	112.62	4638531.0
2010-09-16 14:00:00	SPY	ETF	112.62	112.9	112.6	112.84	13310573.0
2010-09-16 14:30:00	SPY	ETF	112.84	112.91	112.79	112.82	5901531.0
2010-09-16 15:00:00	SPY	ETF	112.82	113.05	112.79	113.0185	19446026.0
2010-09-16 15:30:00	SPY	ETF	113.02	113.12	112.93	113.07	24258203.0
2010-09-16 16:00:00	SPY	ETF	113.08	113.46	112.595	113.38	12410766.0
2010-09-16 16:30:00	SPY	ETF	113.38	113.48	113.34	113.41	2545801.0
2010-09-16 17:00:00	SPY	ETF	113.41	113.43	113.3	113.33	297883.0
2010-09-16 17:30:00	SPY	ETF	113.34	113.39	113.32	113.35	33836.0
2010-09-16 18:00:00	SPY	ETF	113.36	113.5	113.1	113.48	68802.0
2010-09-16 18:30:00	SPY	ETF	113.48	113.5	113.45	113.5	56600.0
2010-09-16 19:00:00	SPY	ETF	113.49	113.54	113.49	113.49	29531.0
2010-09-16 19:30:00	SPY	ETF	113.49	113.57	113.49	113.56	33768.0
2010-09-16 04:30:00	QQQ	ETF	47.65	47.65	47.65	47.65	100.0
2010-09-16 06:30:00	QQQ	ETF	47.72	47.72	47.72	47.72	100.0
2010-09-16 07:00:00	QQQ	ETF	47.68	47.69	47.66	47.68	27096.0
2010-09-16 07:30:00	QQQ	ETF	47.68	47.68	47.63	47.66	6608.0
2010-09-16 08:00:00	QQQ	ETF	47.66	47.68	47.6	47.66	159000.0
2010-09-16 08:30:00	QQQ	ETF	47.65	47.72	47.56	47.63	239098.0
2010-09-16 09:00:00	QQQ	ETF	47.62	47.69	47.6	47.67	187761.0
2010-09-16 09:30:00	QQQ	ETF	47.68	47.74	47.55	47.67	4818601.0
2010-09-16 10:00:00	QQQ	ETF	47.66	47.76	47.54	47.65	6411433.0
2010-09-16 10:30:00	QQQ	ETF	47.65	47.75	47.57	47.7	4146237.0
2010-09-16 11:00:00	QQQ	ETF	47.6999	47.75	47.59	47.6204	4173330.0
2010-09-16 11:30:00	QQQ	ETF	47.63	47.65	47.59	47.61	3392547.0
2010-09-16 12:00:00	QQQ	ETF	47.6117	47.64	47.54	47.61	2857780.0
2010-09-16 12:30:00	QQQ	ETF	47.61	47.73	47.61	47.71	1835882.0
2010-09-16 13:00:00	QQQ	ETF	47.7074	47.71	47.58	47.63	6331102.0
2010-09-16 13:30:00	QQQ	ETF	47.63	47.65	47.59	47.63	1464769.0
2010-09-16 14:00:00	QQQ	ETF	47.63	47.79	47.62	47.77	2886121.0
2010-09-16 14:30:00	QQQ	ETF	47.76	47.82	47.74	47.7961	2735421.0

> showing 50 of 8,410 rows — these rows as CSV

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