PREVIEW / etf_30min / 2012-03-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-23.parquet
  size:    276 KB
  rows:    9,236

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
2012-03-23 04:00:00	SPY	ETF	139.48	139.81	139.48	139.81	11765.0
2012-03-23 04:30:00	SPY	ETF	139.79	139.97	139.79	139.8	35301.0
2012-03-23 05:00:00	SPY	ETF	139.94	139.95	139.62	139.62	15200.0
2012-03-23 05:30:00	SPY	ETF	139.6	139.6	139.4	139.41	24800.0
2012-03-23 06:00:00	SPY	ETF	139.46	139.46	139.36	139.36	3300.0
2012-03-23 06:30:00	SPY	ETF	139.45	139.45	139.31	139.4	32550.0
2012-03-23 07:00:00	SPY	ETF	139.41	139.57	139.32	139.32	951907.0
2012-03-23 07:30:00	SPY	ETF	139.3	139.31	139.09	139.09	179388.0
2012-03-23 08:00:00	SPY	ETF	139.11	139.475	139.05	139.27	1198041.0
2012-03-23 08:30:00	SPY	ETF	139.28	139.38	139.2	139.36	868888.0
2012-03-23 09:00:00	SPY	ETF	139.36	139.37	139.24	139.31	1109828.0
2012-03-23 09:30:00	SPY	ETF	139.32	139.37	138.97	139.11	11953326.0
2012-03-23 10:00:00	SPY	ETF	139.1	139.1	138.55	138.79	16728257.0
2012-03-23 10:30:00	SPY	ETF	138.78	139.23	138.76	139.16	10434119.0
2012-03-23 11:00:00	SPY	ETF	139.16	139.41	139.06	139.4	8027931.0
2012-03-23 11:30:00	SPY	ETF	139.39	139.6	139.39	139.55	8907162.0
2012-03-23 12:00:00	SPY	ETF	139.55	139.58	139.38	139.43	4467732.0
2012-03-23 12:30:00	SPY	ETF	139.4201	139.68	139.33	139.6	5175425.0
2012-03-23 13:00:00	SPY	ETF	139.6	139.67	139.55	139.65	3214879.0
2012-03-23 13:30:00	SPY	ETF	139.66	139.75	139.5	139.53	5532523.0
2012-03-23 14:00:00	SPY	ETF	139.53	139.73	139.5199	139.72	3235917.0
2012-03-23 14:30:00	SPY	ETF	139.73	139.81	139.65	139.68	5356697.0
2012-03-23 15:00:00	SPY	ETF	139.68	139.72	139.57	139.655	4405375.0
2012-03-23 15:30:00	SPY	ETF	139.66	139.75	139.55	139.65	18421834.0
2012-03-23 16:00:00	SPY	ETF	139.66	139.9	139.0	139.87	6692280.0
2012-03-23 16:30:00	SPY	ETF	139.87	139.9375	139.601	139.88	322378.0
2012-03-23 17:00:00	SPY	ETF	139.87	139.9	139.85	139.88	117500.0
2012-03-23 17:30:00	SPY	ETF	139.86	139.91	139.83	139.89	58022.0
2012-03-23 18:00:00	SPY	ETF	139.89	139.9	139.81	139.82	74072.0
2012-03-23 18:30:00	SPY	ETF	139.83	139.91	139.83	139.87	9055.0
2012-03-23 19:00:00	SPY	ETF	139.88	139.88	139.83	139.85	15000.0
2012-03-23 19:30:00	SPY	ETF	139.85	139.85	139.81	139.82	22722.0
2012-03-23 04:30:00	QQQ	ETF	67.39	67.39	67.39	67.39	200.0
2012-03-23 05:30:00	QQQ	ETF	67.26	67.26	67.18	67.18	850.0
2012-03-23 06:00:00	QQQ	ETF	67.19	67.19	67.19	67.19	200.0
2012-03-23 06:30:00	QQQ	ETF	67.14	67.14	67.11	67.13	2000.0
2012-03-23 07:00:00	QQQ	ETF	67.16	67.16	67.13	67.13	5400.0
2012-03-23 07:30:00	QQQ	ETF	67.11	67.12	67.05	67.09	350998.0
2012-03-23 08:00:00	QQQ	ETF	67.04	67.38	67.01	67.08	380966.0
2012-03-23 08:30:00	QQQ	ETF	67.09	67.12	67.06	67.12	122047.0
2012-03-23 09:00:00	QQQ	ETF	67.1	67.11	67.05	67.06	89355.0
2012-03-23 09:30:00	QQQ	ETF	67.06	67.08	66.81	66.85	4618268.0
2012-03-23 10:00:00	QQQ	ETF	66.84	66.845	66.56	66.6231	5466446.0
2012-03-23 10:30:00	QQQ	ETF	66.62	66.8	66.61	66.78	4283858.0
2012-03-23 11:00:00	QQQ	ETF	66.79	66.88	66.7	66.88	2542795.0
2012-03-23 11:30:00	QQQ	ETF	66.875	66.95	66.84	66.9	3335726.0
2012-03-23 12:00:00	QQQ	ETF	66.9	66.91	66.79	66.82	1550486.0
2012-03-23 12:30:00	QQQ	ETF	66.82	66.87	66.76	66.8222	1363474.0
2012-03-23 13:00:00	QQQ	ETF	66.83	66.88	66.78	66.86	1293122.0
2012-03-23 13:30:00	QQQ	ETF	66.87	66.91	66.84	66.8475	3263162.0

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

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