PREVIEW / etf_30min / 2011-03-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-03.parquet
  size:    285 KB
  rows:    9,426

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
2011-03-03 04:00:00	SPY	ETF	131.5	131.55	131.5	131.55	1450.0
2011-03-03 04:30:00	SPY	ETF	131.62	131.71	131.6	131.69	10900.0
2011-03-03 05:00:00	SPY	ETF	131.66	131.99	131.66	131.99	21700.0
2011-03-03 05:30:00	SPY	ETF	131.88	132.0	131.88	131.93	19212.0
2011-03-03 06:00:00	SPY	ETF	131.99	131.99	131.92	131.94	12610.0
2011-03-03 06:30:00	SPY	ETF	132.1	132.33	132.09	132.29	251371.0
2011-03-03 07:00:00	SPY	ETF	132.33	132.33	132.16	132.19	374324.0
2011-03-03 07:30:00	SPY	ETF	132.19	132.25	132.11	132.24	193975.0
2011-03-03 08:00:00	SPY	ETF	132.21	132.3	123.03	132.27	938300.0
2011-03-03 08:30:00	SPY	ETF	132.27	132.54	132.05	132.24	4322851.0
2011-03-03 09:00:00	SPY	ETF	132.23	132.41	132.17	132.39	1242228.0
2011-03-03 09:30:00	SPY	ETF	132.4	132.98	132.39	132.83	24486496.0
2011-03-03 10:00:00	SPY	ETF	132.83	132.91	132.58	132.629	13928937.0
2011-03-03 10:30:00	SPY	ETF	132.63	133.07	132.53	132.9	15118480.0
2011-03-03 11:00:00	SPY	ETF	132.91	133.15	132.39	132.98	9311380.0
2011-03-03 11:30:00	SPY	ETF	132.97	133.23	132.88	133.19	9614738.0
2011-03-03 12:00:00	SPY	ETF	133.19	133.22	133.06	133.11	9556027.0
2011-03-03 12:30:00	SPY	ETF	133.115	133.33	133.09	133.249	4485221.0
2011-03-03 13:00:00	SPY	ETF	133.24	133.325	133.16	133.1601	7773408.0
2011-03-03 13:30:00	SPY	ETF	133.17	133.27	133.13	133.195	5877404.0
2011-03-03 14:00:00	SPY	ETF	133.2	133.5	133.19	133.35	7851122.0
2011-03-03 14:30:00	SPY	ETF	133.345	133.61	133.33	133.58	9435102.0
2011-03-03 15:00:00	SPY	ETF	133.57	133.62	133.44	133.47	8011223.0
2011-03-03 15:30:00	SPY	ETF	133.47	133.6	133.35	133.47	21356257.0
2011-03-03 16:00:00	SPY	ETF	133.45	133.5	130.3271	133.41	10984136.0
2011-03-03 16:30:00	SPY	ETF	133.41	133.47	131.211	133.39	7549226.0
2011-03-03 17:00:00	SPY	ETF	133.41	133.45	133.39	133.43	1078471.0
2011-03-03 17:30:00	SPY	ETF	133.44	133.45	133.4	133.41	62061.0
2011-03-03 18:00:00	SPY	ETF	133.42	133.55	133.42	133.52	502312.0
2011-03-03 18:30:00	SPY	ETF	133.53	133.7	133.53	133.65	34969.0
2011-03-03 19:00:00	SPY	ETF	133.62	133.62	133.49	133.49	16849.0
2011-03-03 19:30:00	SPY	ETF	133.49	133.53	133.47	133.52	32808.0
2011-03-03 04:00:00	QQQ	ETF	57.26	57.26	57.26	57.26	442.0
2011-03-03 05:00:00	QQQ	ETF	57.29	57.42	57.29	57.41	9600.0
2011-03-03 05:30:00	QQQ	ETF	57.41	57.42	57.41	57.42	5500.0
2011-03-03 06:00:00	QQQ	ETF	57.41	57.41	57.38	57.38	1700.0
2011-03-03 06:30:00	QQQ	ETF	57.44	57.6	57.44	57.6	13268.0
2011-03-03 07:00:00	QQQ	ETF	57.6	57.6	57.53	57.53	38052.0
2011-03-03 07:30:00	QQQ	ETF	57.54	57.6	57.49	57.57	754729.0
2011-03-03 08:00:00	QQQ	ETF	57.57	57.59	57.5	57.56	248569.0
2011-03-03 08:30:00	QQQ	ETF	57.59	57.7	57.5	57.61	731563.0
2011-03-03 09:00:00	QQQ	ETF	57.61	57.69	57.57	57.68	382179.0
2011-03-03 09:30:00	QQQ	ETF	57.68	58.05	57.67	58.0206	9227233.0
2011-03-03 10:00:00	QQQ	ETF	58.02	58.12	57.92	58.0496	6280607.0
2011-03-03 10:30:00	QQQ	ETF	58.05	58.2	57.95	58.14	6609092.0
2011-03-03 11:00:00	QQQ	ETF	58.14	58.24	58.11	58.1894	3265992.0
2011-03-03 11:30:00	QQQ	ETF	58.1891	58.27	58.115	58.26	2195677.0
2011-03-03 12:00:00	QQQ	ETF	58.255	58.29	58.21	58.252	1272201.0
2011-03-03 12:30:00	QQQ	ETF	58.2562	58.31	58.23	58.26	1504982.0
2011-03-03 13:00:00	QQQ	ETF	58.26	58.3	58.21	58.2101	1815216.0

> showing 50 of 9,426 rows — these rows as CSV

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