PREVIEW / etf_30min / 2010-08-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-13.parquet
  size:    243 KB
  rows:    8,069

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-13 04:00:00	SPY	ETF	109.0	109.14	109.0	109.14	2643.0
2010-08-13 04:30:00	SPY	ETF	109.12	109.28	109.07	109.07	1890.0
2010-08-13 05:00:00	SPY	ETF	109.1	109.1	108.59	108.59	6100.0
2010-08-13 05:30:00	SPY	ETF	108.55	108.58	108.31	108.37	7700.0
2010-08-13 06:00:00	SPY	ETF	108.28	108.28	108.05	108.15	24050.0
2010-08-13 06:30:00	SPY	ETF	108.16	108.27	108.15	108.16	40000.0
2010-08-13 07:00:00	SPY	ETF	108.17	108.26	108.1	108.19	126887.0
2010-08-13 07:30:00	SPY	ETF	108.16	108.17	107.98	108.11	824795.0
2010-08-13 08:00:00	SPY	ETF	108.12	108.48	107.9	108.03	751404.0
2010-08-13 08:30:00	SPY	ETF	107.96	108.4	107.8	108.37	3168135.0
2010-08-13 09:00:00	SPY	ETF	108.31	108.65	108.1	108.28	1398519.0
2010-08-13 09:30:00	SPY	ETF	108.29	108.89	108.25	108.84	25252597.0
2010-08-13 10:00:00	SPY	ETF	108.84	108.96	108.49	108.63	16702041.0
2010-08-13 10:30:00	SPY	ETF	108.63	108.75	108.32	108.49	11604354.0
2010-08-13 11:00:00	SPY	ETF	108.49	108.62	108.32	108.41	7589831.0
2010-08-13 11:30:00	SPY	ETF	108.41	108.5	108.18	108.41	9445426.0
2010-08-13 12:00:00	SPY	ETF	108.4	108.64	108.385	108.63	6303796.0
2010-08-13 12:30:00	SPY	ETF	108.63	108.79	108.53	108.77	4407074.0
2010-08-13 13:00:00	SPY	ETF	108.7616	108.84	108.65	108.74	6187581.0
2010-08-13 13:30:00	SPY	ETF	108.74	108.905	108.6524	108.68	5309022.0
2010-08-13 14:00:00	SPY	ETF	108.68	108.73	108.55	108.66	5454083.0
2010-08-13 14:30:00	SPY	ETF	108.65	108.76	108.4	108.49	6605718.0
2010-08-13 15:00:00	SPY	ETF	108.48	108.66	108.465	108.53	6665782.0
2010-08-13 15:30:00	SPY	ETF	108.53	108.6518	108.22	108.3	23876943.0
2010-08-13 16:00:00	SPY	ETF	108.29	108.885	108.1	108.18	13511382.0
2010-08-13 16:30:00	SPY	ETF	108.19	108.6828	108.12	108.23	2353671.0
2010-08-13 17:00:00	SPY	ETF	108.23	108.34	108.18	108.31	297333.0
2010-08-13 17:30:00	SPY	ETF	108.31	108.33	108.12	108.13	71039.0
2010-08-13 18:00:00	SPY	ETF	108.15	108.3	108.13	108.28	279283.0
2010-08-13 18:30:00	SPY	ETF	108.28	108.28	108.22	108.24	7600.0
2010-08-13 19:00:00	SPY	ETF	108.23	108.25	108.22	108.23	5065.0
2010-08-13 19:30:00	SPY	ETF	108.23	108.24	108.17	108.17	23247.0
2010-08-13 04:00:00	QQQ	ETF	45.18	45.2	45.18	45.2	200.0
2010-08-13 05:00:00	QQQ	ETF	45.02	45.02	45.02	45.02	783.0
2010-08-13 06:00:00	QQQ	ETF	44.86	44.86	44.78	44.78	839.0
2010-08-13 06:30:00	QQQ	ETF	44.84	44.84	44.82	44.82	40300.0
2010-08-13 07:00:00	QQQ	ETF	44.81	44.85	44.79	44.8	10598.0
2010-08-13 07:30:00	QQQ	ETF	44.83	44.83	44.75	44.77	14094.0
2010-08-13 08:00:00	QQQ	ETF	44.79	44.9	44.7	44.76	297124.0
2010-08-13 08:30:00	QQQ	ETF	44.77	44.91	44.67	44.87	747100.0
2010-08-13 09:00:00	QQQ	ETF	44.86	44.91	44.76	44.88	652722.0
2010-08-13 09:30:00	QQQ	ETF	44.89	45.06	44.7867	44.99	7798171.0
2010-08-13 10:00:00	QQQ	ETF	44.99	45.0296	44.82	44.9	4629708.0
2010-08-13 10:30:00	QQQ	ETF	44.9	44.96	44.75	44.84	3210947.0
2010-08-13 11:00:00	QQQ	ETF	44.83	44.87	44.77	44.81	1905091.0
2010-08-13 11:30:00	QQQ	ETF	44.8078	44.85	44.71	44.8301	2307780.0
2010-08-13 12:00:00	QQQ	ETF	44.83	44.93	44.82	44.92	1170311.0
2010-08-13 12:30:00	QQQ	ETF	44.92	44.96	44.85	44.95	1125961.0
2010-08-13 13:00:00	QQQ	ETF	44.94	44.99	44.9	44.95	955217.0
2010-08-13 13:30:00	QQQ	ETF	44.95	45.02	44.92	44.93	1020385.0

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

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