PREVIEW / etf_30min / 2011-04-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-01.parquet
  size:    283 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-04-01 04:00:00	SPY	ETF	132.77	132.84	132.77	132.84	13000.0
2011-04-01 05:00:00	SPY	ETF	132.71	132.72	132.7	132.7	1000.0
2011-04-01 05:30:00	SPY	ETF	132.75	132.8	132.75	132.8	2550.0
2011-04-01 06:00:00	SPY	ETF	132.85	133.11	132.8	132.87	8450.0
2011-04-01 06:30:00	SPY	ETF	132.87	132.93	132.83	132.93	2600.0
2011-04-01 07:00:00	SPY	ETF	132.94	133.06	132.94	132.99	51125.0
2011-04-01 07:30:00	SPY	ETF	133.08	133.1	132.96	133.04	1120875.0
2011-04-01 08:00:00	SPY	ETF	133.01	133.17	132.51	133.14	1631499.0
2011-04-01 08:30:00	SPY	ETF	133.15	133.44	132.59	133.26	5818190.0
2011-04-01 09:00:00	SPY	ETF	133.28	133.49	132.51	133.41	1903683.0
2011-04-01 09:30:00	SPY	ETF	133.41	133.46	133.0	133.1	16720953.0
2011-04-01 10:00:00	SPY	ETF	133.13	133.62	133.07	133.54	16141951.0
2011-04-01 10:30:00	SPY	ETF	133.54	133.66	133.41	133.54	8264858.0
2011-04-01 11:00:00	SPY	ETF	133.54	133.71	133.49	133.68	8961017.0
2011-04-01 11:30:00	SPY	ETF	133.6825	133.77	133.6	133.67	7788662.0
2011-04-01 12:00:00	SPY	ETF	133.68	133.75	133.64	133.66	3803555.0
2011-04-01 12:30:00	SPY	ETF	133.66	133.67	133.51	133.57	6337487.0
2011-04-01 13:00:00	SPY	ETF	133.5671	133.57	133.43	133.47	5902627.0
2011-04-01 13:30:00	SPY	ETF	133.46	133.56	133.45	133.54	5051755.0
2011-04-01 14:00:00	SPY	ETF	133.55	133.6	133.52	133.56	6481519.0
2011-04-01 14:30:00	SPY	ETF	133.57	133.57	133.12	133.22	10686100.0
2011-04-01 15:00:00	SPY	ETF	133.215	133.22	132.83	133.02	15522431.0
2011-04-01 15:30:00	SPY	ETF	133.01	133.27	132.98	133.16	18261686.0
2011-04-01 16:00:00	SPY	ETF	133.15	133.74	133.06	133.12	8949189.0
2011-04-01 16:30:00	SPY	ETF	133.12	133.22	132.5487	133.19	1052395.0
2011-04-01 17:00:00	SPY	ETF	133.22	133.22	133.17	133.2	75364.0
2011-04-01 17:30:00	SPY	ETF	133.2	133.2	133.16	133.18	21601.0
2011-04-01 18:00:00	SPY	ETF	133.17	133.24	133.14	133.23	89750.0
2011-04-01 18:30:00	SPY	ETF	133.24	133.27	133.2	133.26	11780.0
2011-04-01 19:00:00	SPY	ETF	133.26	133.26	133.13	133.22	24683.0
2011-04-01 19:30:00	SPY	ETF	133.23	133.23	133.19	133.21	8170.0
2011-04-01 04:30:00	QQQ	ETF	57.61	57.61	57.61	57.61	300.0
2011-04-01 05:00:00	QQQ	ETF	57.54	57.54	57.54	57.54	100.0
2011-04-01 05:30:00	QQQ	ETF	57.54	57.54	57.54	57.54	1500.0
2011-04-01 06:00:00	QQQ	ETF	57.58	57.6	57.57	57.6	3500.0
2011-04-01 06:30:00	QQQ	ETF	57.62	57.62	57.62	57.62	20000.0
2011-04-01 07:00:00	QQQ	ETF	57.66	57.69	57.65	57.68	29245.0
2011-04-01 07:30:00	QQQ	ETF	57.66	57.69	57.65	57.66	427700.0
2011-04-01 08:00:00	QQQ	ETF	57.65	57.68	57.61	57.65	1267959.0
2011-04-01 08:30:00	QQQ	ETF	57.64	57.78	57.63	57.67	3753710.0
2011-04-01 09:00:00	QQQ	ETF	57.67	57.72	57.67	57.71	484541.0
2011-04-01 09:30:00	QQQ	ETF	57.72	57.75	57.46	57.53	7293115.0
2011-04-01 10:00:00	QQQ	ETF	57.52	57.77	57.51	57.735	4850203.0
2011-04-01 10:30:00	QQQ	ETF	57.73	57.8	57.647	57.73	2142969.0
2011-04-01 11:00:00	QQQ	ETF	57.73	57.82	57.7	57.82	1970310.0
2011-04-01 11:30:00	QQQ	ETF	57.815	57.9	57.8	57.85	3195071.0
2011-04-01 12:00:00	QQQ	ETF	57.86	57.8699	57.811	57.819	1048893.0
2011-04-01 12:30:00	QQQ	ETF	57.81	57.82	57.75	57.781	1249669.0
2011-04-01 13:00:00	QQQ	ETF	57.7868	57.8	57.72	57.75	1296089.0
2011-04-01 13:30:00	QQQ	ETF	57.7499	57.8	57.73	57.7619	1765156.0

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

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