PREVIEW / etf_30min / 2010-07-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-13.parquet
  size:    264 KB
  rows:    8,717

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-07-13 04:00:00	SPY	ETF	108.08	108.1	108.03	108.1	3250.0
2010-07-13 04:30:00	SPY	ETF	108.29	108.64	108.29	108.6	1600.0
2010-07-13 05:00:00	SPY	ETF	108.6	108.93	108.6	108.93	3500.0
2010-07-13 05:30:00	SPY	ETF	108.9	108.93	108.75	108.88	16700.0
2010-07-13 06:00:00	SPY	ETF	108.86	108.86	108.77	108.85	15700.0
2010-07-13 06:30:00	SPY	ETF	108.79	108.88	108.79	108.79	32300.0
2010-07-13 07:00:00	SPY	ETF	108.79	109.0	108.75	108.99	378501.0
2010-07-13 07:30:00	SPY	ETF	108.99	109.05	108.93	108.99	362670.0
2010-07-13 08:00:00	SPY	ETF	108.97	109.08	108.56	109.06	692610.0
2010-07-13 08:30:00	SPY	ETF	109.05	109.18	109.01	109.12	786972.0
2010-07-13 09:00:00	SPY	ETF	109.13	109.33	109.12	109.15	2381124.0
2010-07-13 09:30:00	SPY	ETF	109.15	109.38	108.93	109.19	29791261.0
2010-07-13 10:00:00	SPY	ETF	109.19	109.59	109.18	109.37	14691793.0
2010-07-13 10:30:00	SPY	ETF	109.37	109.395	109.11	109.25	14000611.0
2010-07-13 11:00:00	SPY	ETF	109.26	109.5	109.21	109.46	8691067.0
2010-07-13 11:30:00	SPY	ETF	109.46	109.89	109.44	109.59	18817114.0
2010-07-13 12:00:00	SPY	ETF	109.5999	109.8	109.56	109.78	11189259.0
2010-07-13 12:30:00	SPY	ETF	109.78	109.82	109.57	109.58	6512036.0
2010-07-13 13:00:00	SPY	ETF	109.58	109.77	109.3	109.39	11544025.0
2010-07-13 13:30:00	SPY	ETF	109.39	109.58	109.27	109.37	6748125.0
2010-07-13 14:00:00	SPY	ETF	109.37	109.69	109.36	109.52	8566129.0
2010-07-13 14:30:00	SPY	ETF	109.52	109.76	109.51	109.7483	8859441.0
2010-07-13 15:00:00	SPY	ETF	109.75	109.97	109.74	109.9401	15374582.0
2010-07-13 15:30:00	SPY	ETF	109.94	110.09	109.6	109.66	32293581.0
2010-07-13 16:00:00	SPY	ETF	109.66	110.29	108.965	110.1	11754205.0
2010-07-13 16:30:00	SPY	ETF	110.06	110.33	108.015	110.23	7257107.0
2010-07-13 17:00:00	SPY	ETF	110.22	110.4	110.21	110.29	297273.0
2010-07-13 17:30:00	SPY	ETF	110.29	110.4	110.27	110.36	176612.0
2010-07-13 18:00:00	SPY	ETF	110.34	110.39	109.66	110.3	134366.0
2010-07-13 18:30:00	SPY	ETF	110.31	110.31	108.02	110.25	212479.0
2010-07-13 19:00:00	SPY	ETF	110.28	110.28	110.24	110.27	40350.0
2010-07-13 19:30:00	SPY	ETF	110.28	110.32	110.21	110.32	97294.0
2010-07-13 04:00:00	QQQ	ETF	44.84	44.95	44.84	44.95	5200.0
2010-07-13 04:30:00	QQQ	ETF	45.03	45.05	45.02	45.05	20250.0
2010-07-13 05:00:00	QQQ	ETF	45.04	45.15	45.04	45.15	800.0
2010-07-13 05:30:00	QQQ	ETF	45.14	45.14	45.14	45.14	750.0
2010-07-13 06:00:00	QQQ	ETF	45.15	45.15	45.15	45.15	600.0
2010-07-13 06:30:00	QQQ	ETF	45.15	45.15	45.15	45.15	500.0
2010-07-13 07:00:00	QQQ	ETF	45.13	45.16	45.09	45.15	179448.0
2010-07-13 07:30:00	QQQ	ETF	45.17	45.18	45.13	45.14	99159.0
2010-07-13 08:00:00	QQQ	ETF	45.14	45.2	45.13	45.18	237327.0
2010-07-13 08:30:00	QQQ	ETF	45.17	45.24	45.16	45.2	292540.0
2010-07-13 09:00:00	QQQ	ETF	45.2	45.26	45.12	45.13	1092774.0
2010-07-13 09:30:00	QQQ	ETF	45.13	45.2	44.8	44.98	15041321.0
2010-07-13 10:00:00	QQQ	ETF	44.98	45.15	44.98	45.07	7717427.0
2010-07-13 10:30:00	QQQ	ETF	45.08	45.08	44.88	44.96	5782631.0
2010-07-13 11:00:00	QQQ	ETF	44.95	45.155	44.95	45.12	4352230.0
2010-07-13 11:30:00	QQQ	ETF	45.11	45.37	45.11	45.21	7503454.0
2010-07-13 12:00:00	QQQ	ETF	45.21	45.28	45.17	45.279	3255092.0
2010-07-13 12:30:00	QQQ	ETF	45.27	45.32	45.19	45.2	2346993.0

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

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