PREVIEW / etf_30min / 2010-08-30

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-30.parquet
  size:    251 KB
  rows:    8,252

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-08-30 04:00:00	SPY	ETF	107.2	107.22	107.2	107.22	2300.0
2010-08-30 04:30:00	SPY	ETF	107.13	107.18	107.13	107.15	7700.0
2010-08-30 05:00:00	SPY	ETF	107.15	107.15	107.15	107.15	200.0
2010-08-30 05:30:00	SPY	ETF	107.11	107.15	107.11	107.13	2475.0
2010-08-30 06:00:00	SPY	ETF	107.07	107.08	107.0	107.08	8750.0
2010-08-30 06:30:00	SPY	ETF	107.08	107.1	106.89	106.89	11925.0
2010-08-30 07:00:00	SPY	ETF	106.87	106.98	106.75	106.86	158785.0
2010-08-30 07:30:00	SPY	ETF	106.89	106.98	106.81	106.83	89610.0
2010-08-30 08:00:00	SPY	ETF	107.1	107.1	106.74	106.76	1994209.0
2010-08-30 08:30:00	SPY	ETF	106.79	106.98	106.54	106.65	2908178.0
2010-08-30 09:00:00	SPY	ETF	106.65	106.76	106.55	106.58	2153924.0
2010-08-30 09:30:00	SPY	ETF	106.58	106.91	106.49	106.86	16505857.0
2010-08-30 10:00:00	SPY	ETF	106.85	106.9	106.35	106.47	17775267.0
2010-08-30 10:30:00	SPY	ETF	106.47	106.8472	106.3	106.61	9735118.0
2010-08-30 11:00:00	SPY	ETF	106.62	106.65	106.32	106.4401	7511332.0
2010-08-30 11:30:00	SPY	ETF	106.45	106.47	106.04	106.17	10154578.0
2010-08-30 12:00:00	SPY	ETF	106.175	106.23	106.1	106.17	3522222.0
2010-08-30 12:30:00	SPY	ETF	106.17	106.46	106.12	106.28	6286376.0
2010-08-30 13:00:00	SPY	ETF	106.27	106.39	105.97	106.0206	8831293.0
2010-08-30 13:30:00	SPY	ETF	106.02	106.14	105.94	106.01	6179229.0
2010-08-30 14:00:00	SPY	ETF	106.0	106.11	105.78	106.04	8057513.0
2010-08-30 14:30:00	SPY	ETF	106.038	106.17	105.9	105.9901	6368658.0
2010-08-30 15:00:00	SPY	ETF	105.99	106.05	105.66	105.71	9735741.0
2010-08-30 15:30:00	SPY	ETF	105.71	105.82	105.3	105.33	29832943.0
2010-08-30 16:00:00	SPY	ETF	105.32	106.9008	105.02	105.08	9976944.0
2010-08-30 16:30:00	SPY	ETF	105.07	105.17	105.02	105.15	557374.0
2010-08-30 17:00:00	SPY	ETF	105.15	106.9008	105.02	105.09	2101422.0
2010-08-30 17:30:00	SPY	ETF	105.07	105.1	105.03	105.06	28150.0
2010-08-30 18:00:00	SPY	ETF	105.07	105.16	105.07	105.1	102400.0
2010-08-30 18:30:00	SPY	ETF	105.12	105.15	105.11	105.14	48553.0
2010-08-30 19:00:00	SPY	ETF	105.14	105.34	105.14	105.21	56258.0
2010-08-30 19:30:00	SPY	ETF	105.22	105.32	105.18	105.25	163665.0
2010-08-30 05:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	100.0
2010-08-30 06:30:00	QQQ	ETF	44.1	44.1	44.05	44.05	500.0
2010-08-30 07:00:00	QQQ	ETF	44.01	44.04	43.96	44.04	43392.0
2010-08-30 07:30:00	QQQ	ETF	44.06	44.1	43.98	44.0	463600.0
2010-08-30 08:00:00	QQQ	ETF	44.0	44.04	43.98	43.99	2394380.0
2010-08-30 08:30:00	QQQ	ETF	43.99	44.04	43.84	43.91	2393141.0
2010-08-30 09:00:00	QQQ	ETF	43.91	43.93	43.87	43.87	2100676.0
2010-08-30 09:30:00	QQQ	ETF	43.87	44.24	43.86	44.23	9365347.0
2010-08-30 10:00:00	QQQ	ETF	44.22	44.25	43.99	44.025	6127464.0
2010-08-30 10:30:00	QQQ	ETF	44.02	44.17	43.96	44.11	3208699.0
2010-08-30 11:00:00	QQQ	ETF	44.11	44.13	43.99	44.05	2356459.0
2010-08-30 11:30:00	QQQ	ETF	44.0585	44.07	43.85	43.89	2175784.0
2010-08-30 12:00:00	QQQ	ETF	43.9	43.9455	43.8659	43.91	1272884.0
2010-08-30 12:30:00	QQQ	ETF	43.91	44.0265	43.89	43.97	1289659.0
2010-08-30 13:00:00	QQQ	ETF	43.97	44.0127	43.82	43.86	1863792.0
2010-08-30 13:30:00	QQQ	ETF	43.86	43.92	43.83	43.84	1569541.0
2010-08-30 14:00:00	QQQ	ETF	43.84	43.905	43.77	43.89	1556056.0
2010-08-30 14:30:00	QQQ	ETF	43.89	43.96	43.85	43.8939	1804345.0

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

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